Drupal is pretty good. I've used it before - but like others said, it is not very intuitive. Very nice though, either way.
Another method, which is often overlooked, is implementing forum software. You can use phpBB and a script called Fetch-All and make a really nice site.
Fetch-All can fetch posts in your forums, statistics, threads - anything, and then display it however and wherever you'd like. I used to use this system and its really quite nice. You will have to edit a php file here and there, but only simple stuff.
If you are looking for a forum-based website and you want an active forum, such as here, I would look into phpBB and Fetch-All (both free).
I currently use phpBB2 Plus, which is mostly a portal system to a forum, but it works for the purpose of my site (found in my sig).
If you want to just manage your own content (aka not so much a forum) then I would look into Drupal and some of the others mentioned above, although I have not tried any other but Drupal myself.