Damn, what a tough question!
I'd have to say Loreena McKennitt's 'The Visit.' The combination of excellent female vocals, varied accompaniment and tempo, and good recording quality just about guarantees that there will always be at least one song on this album that will suit my mood, no matter what it may be.
http://www.quinlanroad.com/explorethemusic/thevisit.asp