There's a few of mine that have already been mentioned, like Gorillas In The Mist, Beaches, I Am Sam, Green Mile.
But, for me, the final scene to Ghost has always been the saddest scene i've ever seen, that beautiful piece of music does it for me as well as the line: "I love you Molly, i've...