Well, here is my site:
WiseTome.com
It is running on Drupal 4.7
Mind you. That is a very simplistic design I chose. And it has not been updated a lot. I am concentrating on a blog under it now. Soon, I plan to expand the effort to the main site itself.
There are better examples like the Drupal site itself.
Things that I like about Drupal:
- Open Source with a huge community
- All content is considered as a node - no sets of content are inherently categoriezed. That gives you maximum flexibility. You can use any subset of the contents in the DB anyway you choose and show them any way you want.
- Powerful categorization/taxonomy module (this added to the node system gives the basic flexibility and power of Drupal).
- All features are modules. For example, if you activate the comment module, they can be used against any kind of content you have at the site.
Dislikes:
- It is a bit hard learning curve. Because of the immense flexibility, it looks very complicated
- No proper integration with phpBB like Joomla/Mamboo. I do not like this. But I think they have integration for vB. Just go through the contributed modules and you should find it.