My middle child hates all things sporty and he is also pretty physically awkward (in contrast to my oldest and youngest who are successful and super involved in their respective sports). For years, I forced my middle guy to do sport-activities. We tried baseball, fencing, tennis, swimming, and probably others that I can't recall. He was pretty miserable doing all of it (tennis was the closest we came to finding a sport for him). However, a few years ago I started sending him to sleep-away camp for a month every summer. He loves it. Sure, while at camp, he often chooses less-sporty activities such as arts/crafts or fishing. But he also really loves activities like archery and riflery. And he is willing to try things like rock climbing and sailing. I also love that his camp does overnight trips out of the camp (canoeing, hiking and even mountain biking). He has really flourished in this environment. Next summer we are looking at 8-weeks of camp (I will miss him!!).
Also (and this is important!) I have learned to accept him for who he is -- a kid who does not like sports, but prefers art (he loves pottery), computer programming and chess. He is his own amazing person. And he is much happier (me too) now that we are not trying to shove a square peg into a round hole.