In my last LJ entry I listed five favourite deaths from books and comics and then said, I can't think of any deaths in movies or television that would come even close.
I am an idiot. Or at least... I have a bad fannish memory.
The death of Boromir in the movie version of The Lord of the Rings: the Fellowship of the Ring gets me every time.