So far, MODx is working very well for a couple of clients. It has a great facility for Google-friendly/
SEO stuff and is so XML-ey that the learning curve was pretty painless.
It did point out some glaring weaknesses in our CSS skills, though, so we learned - which was a skill update we needed anyway.
We were glad to not have to reinvent the wheel for once, and it really works well with mySQL, even custom table configurations. Documentation could be a bit better, but that seems to be a shortcoming of most open source stuff.
And all of the underlying stuff is PHP, so if you are able, the possibilities are pretty endless.
We moved to a RAD package for PHP a while back that tends to be more design/usability centric and generates all the code for you. Greatest thing is that you can output the results of your work in php, asp, etc. This has required fewer coders to do generic jobs and let us get more done without having to find more coders, and was considerably less expensive than offshoring.........
CodeCharge Studio for Rapid Web Application Development and Visual Web Reporting; DemoCharge Screen Recorder