So far I have setup two experimental blog sites (both using MySQL and PHP), two wikis (both using PHP+text files, one with PHP+MySQL)
and a Drupal based site - boy is that impressive !!!
If you want to have a look (no content yet but you can get the idea) checkout ...
www.lairdswood.com/drupalwww.lairdswood.com/pmwiki/pmwiki.php (yes I know I can't spell, this uses text based files to store the 'pages')
www.lairdswood.com/mediawikiwww.lairdswood.com/weblogs (based on bblog)
www.lairdswood.com/weblogs/wordpressSo far I am most impressed with Drupal (is there anything it doesn't do out of the box?)
Of the others PMWiki is quick and easy to setup and has few overheads, MediaWiki has becaome a standard (though it isn't that easy to set up or manage from the limited look I have had), no so impressed with bblog - the blog pages look ok but the whole thing feels a bit amateurish, WordPress is quite impressive (but it was hard to set up as there was a PHP bug which has survived various version updates - ridiculous).
Drupal installation was quite complicated (it meant getting your hands dirty in MySQL and if you want to prefix all your tables you have to manually edit some scripts). It wasn't helped by the fact the latest version requires a later PHP than my provider supports, and all the documentation refers tot he latest version (which is different)!!!
I'm going to write up a full description of my experiements ... coming soon