I have to be in a real crappy mood already for a song to make me cry.
Only ones I remember are:
Loreena McKennitt (or anyone, really) - Anachie Gordon
Lunasa - Autumn Child/Heaton Chapel
D-A-D - Grow of Pay
Dire Straits - Hand in Hand
Fairport Convention - Crazy Man Michael
Skyclad - Jumping My Shadow
Sol Invictus - Sheath and Knife
Alright, alright, I'm a pussy too.