The not cheerful songs are usually the best in my opinion. I hardly have any cheerful songs. I have one CD (Demons and Wizards) that has one song on it in a major scale (thus sounds a bit cheerful) and has a positive text, all other songs are less positive and in minor scales. Guess which song I like least?
On with their heads! I'm the clown prince of fools
if you don't get the joke it's your loss
Love and laughter you see are the new currency
'cause greed's coinage is not worth a toss