I don't think many songs make me feel very emotional but,
The end of Eclipse on Dark Side of the Moon by Pink Floyd.
Here's the last two songs.
'but the sun is eclipsed by the moon'.
Cats in the Cradle is an obvious one.
Especially after reading the Youtube comments.
There might be others I can't remember now.