A metro station doesn’t look like a Gucci store and that’s just fine and perfectly appropriate.
What I don’t like about this list is that it focuses on Gucci and not on metro stations. You can’t design a metro station like a Gucci store, you can’t design a high-traffic web app like a designer portfolio.
And really, what's wrong with style over substance? It's not like a firm needs to have a Reddit/Gmail style of a design.
I, like you, use Facebook, Gmail, and Reddit quite a bit. However, I don't consider their design to be as outstanding as their functionality (which I know we'll disagree with). Thus, I wouldn't say they are my favorite web designs.
They are a chair that looks really great from a distance, but that you can't sit in. It's pretty and pointless.
If the purpose of your site is to impress potential clients then there's absolutely nothing wrong with: http://www.dawghousedesignstudio.com/
If the purpose of your site is world domination of classified ads then there's absolutely nothing wrong with: http://toronto.en.craigslist.ca/
The rest are pretty minimalistic and function focused.
1) They're pretty
2) They piss me off
These sites scream style over substance. I can't think of an Alexa top 500 site that uses this kind of design. The only one I frequent would be Grooveshark, and their design is highly functional.
Between facebook, gmail, reddit, HN, and the various blogs and news sites I visit, 98% of my time online is spent on sites that look nothing like these. Even Hipmunk, while very web 2.0, is completely function-focused. These sites seem like they're pretty for the sake of being pretty, and I couldn't for the life of me say what a single one of them actually does.