We watched that on my Film Studies course at Uni, i didn't cry but it was indeed a sad ending:(
For me it would have to be 'The Green Mile', it's the musical score that really hits it home.
Also, 'Star Trek II: The Wrath of Khan' (The lines "You have been, and always shall be, my friend", and...