You hear people often about "swimmer's bodies": broad shoulders and narrow waist (V-shape), long legs and arms, not too low body fat percentage, medium amount of mass, toned & elongated muscles.
Also ancient pentathletes (modern day decathletes). Aristotle in Rhetoric: "a body capable of enduring all efforts, either of the racecourse or of bodily strength...This is why the athletes in the pentathlon are most beautiful"
For the "current" standards of good looking and for skill levels attainable by people having a life (and/or job) it would be probably something like that (roughly in descending order):
* Basketball (for women tied with Volleyball)
* Decathlon (men)
* Sprint (men - women equivalent would be long and high jump)
* Boxing (all variants but only for lower to "normal" weight classes)
* Judo/Wrestling/BJJ/Gymnastics (lower to "normal" weight classes... maybe to sinew for women)
* Rowing/Kanu
* Olympic Weightlifting (lower to "normal" weight classes)
* Powerlifting (again lower to "normal" weight classes, additionally not at elite level)
* Swimming (men... women a probably higher in this chart)
If you allow "newcomers", I would add to above list CrossFit in the upper third for men (lower third for women) and Kettlebell (lower to "normal" weightlcasses) in the lower third.
Swimming would have been higher in the past, but for today's "standards" it allows a to "high" level of body fat compared to the other sports.
Football (aka. "Soccer") players only start to look "good" at a pretty high level (if they're not doing anything else), the same probably holds true for Baseball.
Additionally some positions in American Football (e.g. Receiver) and some Skiing variants would be ranked quite well.
Kanu? If you mean kayak, I disagree. Kayaking is good for upper body strength, but (exaggerating) atrophies the legs.
Also, I think there is a difference between 'good on average', and 'good for those who manage to do a lot of it without getting injured'. For example decathlon training is good for overall 'athlete look', but the risk of dropping out with some injury is fairly high.
For that reason, I would rank the impact-free sports such as swimming, cross-country skiing and rowing a bit higher.
You know that the best sportsmen, and that includes the best soccer players, don't just perform their sport, but also do, say, auxiliary strength training?
The sprinters have to be very muscular for the short-term power they need and at the same to have very low body-fat as to not carry around any extra weight.
All of the sprinters look like they could be on the cover of Men's Fitness.
