the wedding scene in Armageddon.

Highlander - for those of you not familiar with this one, the Highlander is immortal, but falls in love with a mortal woman who grows old as he stays young. He is holding her as she dies while the song "Who wants to live forever" is playing. Gets me every time.