Agreed ... static html pages is so 90s. I use a phpbb forum with a CMS (mxbb, now mx-publisher) over the top of the phpbb. It's not as polished as the others, but it's powerful. Unfortunately, they're stuck at phpbb 2.0.x ... they're beta testing a version to work with phpbb 3.x, but it's not production ready yet.
I tried Drupal, Joomla and some others, but couldn't get the hang of them ... but to each his own.