Asheron's Call 2 did a decent job of integrating music. If I recall correctly, the music subtly changed based on the creatures around you even. It was too subtle because few people noticed it, but it was cool. Anyway, I actually have an entry on my blog about music and an "epicitude" system that I'd like to see in a game.

Nerfbat » Creating Emotion in Games Through Sound