I have a VERY deep competitive drive. As a kid I was VERY uncoordinated. Couldn't run, catch, throw. My NT father perservered and got me active (he was a fitness "nut" himself.) While I didn't have any friends playing sport with my dad got me out and active and now I am quite good. While I still dislike the physical contact (I have tactile defensiveness) in basketball (the game I play) I now can run, catch, throw in a coordinated manner that I am a very good player. I play in a premiership winning team in Division one, (and on a different night Division 4) basketball teams. And have picket up three league MVP trophies. Which are amongst my most treasured possessions.
And to those that have said "competition is about somping other people" or "to make yourself feel good at others expense." Its about testing yourself. Testing your skills and your mental toughness. About showcasing the skills and abilities that you have spent many, many, many hours training. Not about beating other people but about continually getting better yourself and overcoming obstacles.
Apart from that. Competition isn't always about beating other people. This extends to almost every aspect of my life. I am always trying to "outdo" myself. In the same way that I would develop the skills for basketball by relentlessly training that which I am worst at, I try and develop those areas elsewhere in the same fashion. Of course, I must see it as a goal. Which probably explains why I never got that into training my social skills. But when I took up swing dancing, I was never going to enter a competition. I only did it because, firstly I liked jazz, and secondly because I wanted to learn to tolerate my tactile defensiveness. And while there are dance styles that get you close to a woman, swing dancing has a nice medium that isn't so close that the sensations overwhelm my ability to cope with them and not so little that I don't have great difficulty with them.
But I still practiced hours by myself (I am still quite uncoordinated so I kinda need to practice extra anyway just to be passable) in order to be as good as I could be. To get a smoothness and fluidity to my movements. And thats not just churning out a hundred moves. But watching tapes of the greats and developing poise and rythm. I typiclaly use only a "few moves" and most of them are designed to make my partner look as good as possible. But that is what being a good dancer (male part) is all about. Not many people care about seeing a guy do a spin. But get a girl swinging around and shaking her hips... well, there aint no better sight on a dance floor than a woman hitting her moves.
Anyways... slightly offtopic. In conclusion: I don't see competition about making other people look bad in order to make myself look good. Its about putting in the dedication to learn the skills and then testing yourself by overcoming obstacles. Whether it be benchmarks you've set for yourself, scoring more than an opponent(s) or simply going out and trying valiantly and doing your best no matter what. That's what competition to me is.
EDIT: I think competition brings out the best in people. It is a showcase for one persons willingness to put in the hard work it takes to win by a quater of a second. Or if their genetics doesn't allow it to reach the full potential available to them by using the sharpness of their mind to devote themselves to focus on a goal and set about acheiving it. Which I see is the place of sports. To give inspirational fuel to those whose goals aren't defined by seconds or milimeters. Whose goals are measured over lifetimes and success over years. By watching sport it crystalises their struggle and seing someone go out and achieve in the space of a minute, or an hour (or however long the competion goes for) so that they can get a lift for their own battles they'll face come monday morning (or whenever.) I can't see how anyone could not help but get an emotional lift from seeing someone like Lance Armstrong win a Tour de France. or Michael Phelps storming to a victory. Or Usain Bolt flying to the limits of human ability, or Johnny Wilkinson hitting a field goal in extra time to win a World Cup... etc... (bastard) It is the role of sports to conctretize the battle to achieve so that those whos goal are more subtle to continue on between achievements.