I like Joomla and along with our site being a Joomla site, I've dabbled in a couple of hobby job sites for customers, and my personal website is also Joomla. It's easy to use, very modular, and Google seems to really like it
The only thing not "out of the box" on the RSS site is the Fireboard forum that's active in our staff login area and allows staff to chat, banter, and bitch about how slowly the night's gone.. ooh, and our job application form is Performs
On the subject of user activation, I found a very useful tweak that sends the account activation email to the website admin rather than the user - something we had to do in order to stop the influx of cheeky chappies setting themselves up and downloading our forms from inside the fireboard.