Michael is doing some ambitious work on his blog. He’s looking at integrating his photos and his gallery (basically his portfolio). iPAP was brought up as an alternative for the photos – I second the recommendation. For a simple CMS, I might look at Mambo. It can handle quite a lot, but I think it can be set up pretty lightweight.
MY experience is certainly with the more “industrial” CMS apps (Interwoven, Vignette, Stellent, Percussion, among others) and similar third party software (Plumtree Portal, etc.), however, I’m always wishing we were dealing with a more flexible, nimble piece of software.