The biggest problem I have found with CMS systems is once you start adding your own content from a database.
Once you start doing this, you typically have to write your own modules as adding php/asp/perl/etc coding to a basic CMS page is not possible (in most cases of CMS’ that I have tried.
Because of this, I moved all my sites off of Mambo/Joomla/Drupal some time ago. I decided NOT to spend the time figuring out all the in’s and out’s of coding modules. With that said – I HAD created several Mambo mods so that I could bring my jackpots onto the main page… just didn’t want to keep coding more mods for each ‘thing’ I wanted to do.
Now – I created my own CMS system which works much better for me. Plus I created some coding that will generate static pages for me when necessary from my database info.
Not sure if that helps… But it is certainly something to think about when using a CMS.