The closest I've come to crying was a song called Last Kiss by Pearl Jam, though originally by J. Frank Wilson and the Cavaliers. It always chokes me up. Pearl Jam did a nice job on it.
Mark
If your interested, here is a link to the lyrics and story behind the song:
http://www.jimbowieband.com/Lyrics/last_kiss.htm