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.

Some folks (mostly low-technical) use Drupal the way it is to have a full-featured website right out of the box without to much fuss. Some Drupal websites are developed by all degrees of professionals with all different skill sets. Ya never know!