I was about as nonathletic a child as it's possible to be, and I discovered in college that I had a real talent for ballroom dancing. I danced competitively for about fifteen years, and became New England and Eastern US amateur champion in my division (American smooth). It is definitely hard, hard work, but I found it to have a lot of the advantages of team sports, but with a much smaller "team."

The downside is that the ballroom world can be very image-conscious, and it's hard to succeed without the "right" kind of body at the top levels. But you can go a long way before you hit that ceiling, even if it applies.