It can be the melody, the lyrics or an association to an event.
For me, I always feel sad when I listen to
Zager & Evans - In the year 2525 (the lyrics)
Michael Andrews & Gary Jules - Mad world (the lyrics and the tune)
Roger Whittaker - The last farewell (the lyrics and the tune)
Anyone got any others?