Have a look at The Vintage Aviator if you want to see a really nice example of a website. Plus it is implemented in Drupal. The only negative comment I would have is that the page load time is rather slow, but that could be because the site has just come out and is getting a lot of coverage.
Here is a link to an article by the author on the story of how he build the site and what tools he used: http://drupal.org/node/267393