Kat is the local Drupal junkie. No question the resource for everything Drupal and also has put up a few nice sites if you haven't yet peeked.
I've decided to go a completely different route. Here's my take. I've had it with PHPFox. Supposedly the new 1.5.1 version is going to be released last Monday (did that make sense? lol) and even with those versions it isn't compelling. I haven't yet looked at the themes section but the 20 new free themes all suffer from the same horrific instantly recognizable look and feel that the prior version did.
Drupal - lots of promise and some superb features that make it the best pure publishing solution out there. Unfortunately IMHO to get to the level you see in the lists above it requires a significant outlay of cash. There also aren't a ton of resources out there to get what you want done quickly, e.g. high quality plugins.
I'm using a bunch of different scripts that integrate with each other to some degree and putting together my own. Total cost of the scripts (vbulletin and others) and added plugins comes out to roughly $500, which I find acceptable. That's a lot of functionality and a nice look in one package. Some of the other stuff will cost me in development but at least I'm going somewhere and not waiting for a mediocre package to continue to move forward slowly. Honestly, I haven't seen many active PHPFox sites - those with many memberships yes, but not active members. I think it may say something about the software too. But that is just IMHO.