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
A great article can be found here: CMS Showcase: 31 Remarkable Drupal Powered Websites which lists (as you may guess) 31 excellent sites.
It is great that an image of the home page of each site is posted, but it would have been even better if a few words were said about each site, particularly what makes them "remarkable".
Here is how to install Drupal on a Centos5 Linux installation
Install Centos5 including web server and mysql
log in as root
Update to latest version with: yum -y update yum ; yum -y update
Install modules with: yum -y install php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel system-config-securitylevel-tui
Note that this is called system-confi-firewall in CentOS 6
Enable .htaccess: cp /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.original vi /etc/httpd/conf/httpd.conf and in two places change AllowOverride None to All (may not be needed in CentOS 6
Uncomment NameVirtualHost *:80
Start apache with: service httpd start
Run: system-config-securitylevel-tui and enable firewall for ssh and http, plus port 10000 for webmin
Open a browser window pointed to the server to check if apache is running
Create default page: echo "<html><head><title>Name of Server</title></head><body><h1>Name of Server</h1></body></html>" > /var/www/html/index.html
Make sure server is running by visiting: http://servername/
Create test script: echo "<html><head><title>Test Page</title></head><body><?php phpinfo(); ?></body></html>" > /var/www/html/testphp.php
Make sure php is running by visiting: http://servername/testphp.php
download and install webmin:
WMVER=1.630-1
wget http://prdownloads.sourceforge.net/webadmin/webmin-$WMVER.noarch.rpm
rpm -U webmin-$WMVER.noarch.rpm
system-config-firewall #to open port 10000
Check it is working by visiting: http://servername:10000
Use webmin to create a virtual server at /var/www/html with no server name. (This will be the default and must come first)
Ledalite has a very attractive new website using Drupal. It is a table-less theme with some javascript effects and subtle shading that makes the site pleasant to look at and to use. The "product quick links" is an interesting feature. There are also some very nice image galleries on the site.