I'm a fan of Mambo, and I recommend it for any of the uses you mention.
This "change of direction" is worth observing for anyone interested in the Open Source movement. Mambo is preparing to take an important step. This will answer the question "Is it possible to have the best of the both worlds, by having a 'young' technology begin its life as Open Code, so that you get as many 'hands' into it as possible, evolve the product (etc, and all the other reasons OSI is good), and then -- when a level of market maturity has been reached, to 'privatize', as it were" --
2HP