How about On the Road From Srebinica (SP?) by Tom Paxton sad song with a message of hope at the end but still brings me down.

Cats in the Cradle by Harry Chapin Even though it's not a sad song, I find Circles by Harry Chapin so beautiful it makes me slightly teary eyed. (not that it takes much).