Unchained Melody by the Rightous Brothers is one that has always tugged on my heart. While the song is older than the movie, movie Ghost really made it a tear jerker.

It's also one of my favorite songs of all times.