#1 of all time for me: "The Face of Love" - duet with Eddie Vedder and Nusrat Fateh Ali Khan, from the "Dead Man Walking" sound track. The raw emotion in this song just rips my heart out every time. Listen to those voices!! It is beauty and joy mingled with pain and desperate, hopeless love. If I'm driving my car when this song comes on I literally have to pull over until I've cried it out.
A good runner-up: "Off He Goes" - Pearl Jam (No Code) - ok so I guess Eddie Vedder gets to me - but this song is about the hope and joy of rediscovering old friendships, and the sadness and disappointment of losing them again. Oh, the lost opportunities! How we wish we had done things differently, way back when! The yearning for that past that will never be again...