Talents can go either way IMO. They can make someone look more attractive but they have the potential to be off putting in a couple of ways. Some people overrate their talent a bit and try and make too much of it and make out they are bigger than they are. Guys are probably worse for this than girls though. The main culprits for this usually involve either sport or music: in either case if you play at local/amateur level then its pretty cool as a hobby but if you try and make out like you're a superstar then its a bit cringeworthy. Social media is bad for this, some people will have their social media full of pictures of themselves playing sport or playing the guitar and constantly bombarding everyone on their friends list to come and watch them play.
The other way in which a talent can be off putting is when its something that can exclude your partner a bit. If a girl is great at gymnastics or dance etc, and she spends loads of time doing it, then a guy might think thats pretty cool and impressive and it makes sure she has a hot body etc, but if the guy doesn't do those things himself then that's an important part of her life that he doesn't share. This can cause problems and resentment when she spends a lot of her time with other guys that do that activity with her.
In terms of talents I find attractive, I like it when a woman can speak different languages but on a more simple level I like it when a woman is good at speaking in public and assertive enough to take charge of social situations and be able to deal with different types of people and be charming and make them feel good, that sounds simple but its actually quite an advanced skill.