An Individual Sport Is Ideal
Some children thrive best when competing against themselves.
My son used to play soccer and basketball in middle school. He was not the best team player, so we steered him toward individual sports in high school.
Track and cross-country seem to suit him, since he can focus on beating his own time rather than on cooperating with others. They have taught him self-discipline and helped him a develop a good work ethic.