There's a neat article here about the power of the Drupal system in term of creating a good-looking website. It all depends on the skill of the developer. There are al sorts of websites showcased including media, entertainment, news, special interest, and... Nissan Russia? Yep. Update: the link is broken, but the screenshot is still good.