Most of The Wrestler. ( admittedly, not the ending)
The death of Spock in Star Trek (2?).
And for some odd reason, every time I watch the Empire Strikes Back, I almost flood in to tears when Vader tells Luke he is his father. ( I'll avoid putting that in spoiler tags if thats ok).