People design some pretty amazing sites with Drupal. Although I'm not even close to the level of the people who have designed these sites I take great inspiration from seeing what is possible. The three Drupal-powered sites whose screenshots I've included are (from left to right) SonyBMG MyPlay, Spread Firefox and Twit.tv.

These sites are great examples of how you can use Drupal to build an aesthetically attractive community while including rich media. The developers of the SonyBMG site were kind enough to post a tutorial about how they built the site. It's a recommended read.