There are many, many songs that make me emotional. I can't help it, I love music. Almost every pivotal moment in my life is relived during a particular song.
The songs that don't have a specific memory, but instead, cause emotion due to the writing for me are:
Cats in the cradle. -HCC
Don't take the girl -TM
Lightning Crashes - Live
Down in the Willow Garden - EB
Barbara Allen
Long Black Veil
"Willie McBride" a/k/a "Green Fields Of France." Written by Eric Bogle, performed by a myriad of stars but the version I always think of is by the Clancy Brothers, just heart wrenching. The waste of young men's lives and the futility of war.
"Well I hope you died quick, and I hope you died clean
or Willie McBride, was it slow and obscene."