<p>
[quote]
Yale is a great school but I believe it lacks somewhat socially. The residential colleges are obviously amazing. But New Haven isn't exactly the most exciting city. Most of the bars/clubs are sketchy with "Bar" being one of the few cool hangouts. Toad's is a pretty good place to see live bands but that has to get old after awhile. Chapel and Broadway have some nice restraunts, the "Butteries" are pretty cool, but I don't know if that makes it top 10 socially.
[/quote]
Only 2 of the OPs 10 listed qualifications involved the surrounding city: musical scene and urban life/arts. As far as the "arts" part of urban life/arts goes, Yale creates plenty of that itself, with possibly the best university theater in the country, good museums, and strong music programs. Urban "life" is admittedly weak, and the musical scene probably isn't as good as it would be in Boston or New York. Regardless, those are only 2 of the 10 categories the OP created as criteria, and many of the other top 20 schools are just as weak in them, if not weaker (are Palo Alto, Durham, Hanover, South Bend, Princeton, or Ithaca particularly more vibrant cities than New Haven).
As far as the remaining categories go:
"Welcoming nature and friendliness of the students": Extremely subjective, but I would say Yale is as good as any.
"Athletic scene for entertainment purposes, ie, sports teams": As good or better than most of the top 20 (for instance, unlike Harvard, alcohol is allowed at tailgates), with obvious exceptions (Vanderbilt, Stanford, Duke, Northwestern, Rice, and Notre Dame)
"Greek life (good or bad)": As I mentioned earlier, I'm confuse by what counts as good in this category, but I think Yale has a healthy balance of active frats with significant membership, but that do not dominate the social scene
"Strength of party scene": Again a subjective category, but is Yale actually worse here than the other top 20 academic schools?
"Size, diversity and cohesiveness of the student body and how this impacts social life": Residential colleges ensure that everyone at least lives in a diverse community, unlike at colleges where students can self-segregate in housing much more easily.
"Weather and its impact on social activities": So the Southern and California schools win in weather, but only about 5 schools on in the top 20 fall into the category of having weather definitively better than Yale
"Student activities including community service, club activities, intramural sports, etc.": Yale shines here, with its extremely active student body, and its plethora of activities that compare favorably with those at any other school.
"Alcohol and drug scene": At least for the "alcohol" part, Yale is better than any of its peers. The university's policy of treating alchol as a health issue, not a disciplinary issue means that students have easy access to alcohol, don't have to worry about being caught drinking (so it isn't necessary to drink in secret behind locked doors as it is at some of the schools listed) and when someone gets dangerously drunk, they don't have to worry about getting in trouble if they seek medical attention.</p>
<p>Overall, Yale is certainly better than Columbia (unless you are a huge New York City fan), Harvard, WashU, MIT, Cornell, Princeton, and Notre Dame (unless football is extremely important to you). It is as good as Brown, Dartmouth, and Penn, and compares decently to Stanford. I don't know enough about Vanderbilt, Northwestern, Rice, or Emory to comment, though I
would say that Vanderbilt is almost certainly better.</p>