This is such a touchy subject... I come from PHP-Fusion. It's pretty fast, flexible and hasn't progressed to far into the development world with OOP and such. It's big downfall is its licensing - AGPL. Meaning if you alter or build upon the CMS you have to share it UNLESS you purchase a license for ONE domain. E107 is highly comparable to PHP-Fusion even to the point where in the past their were feuds over stolen code. E107 in my opinion is in a better place than PHP-Fusion although I am currently helping the development team for PHP-Fusion to push out there latest version.
Other cms's like drupal, wordpress and joomla just seem overkill to me and aren't exactly friendly to beginners to who try to extend functionality. Those types of CMS's have a very high learning curve and for me are very hard to even understand what the hell is going on.
In the end it comes down to what you need. If you can find a complete package that suits your needs out of the box then I suggest you use that. If you've got software that doesn't already have the components of what you want then you'll need to code them yourself, hire a developer or buy an addon - if available.
I recently just started building my own CMS off a user system just because it'll give me all the power I need....