Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Star Trek: Generations
The "death" of the Enterprise D may not be as heartwrenching as that of the original ship, but when it's out-right stated that she can't be salvaged, that gets me everytime.
The "final" death of James T. Kirk, Captain of the Enterprise. Now that death scene ALWAYS gets me, every single time.
While the way in which he died might be poor, the death scene itself is amazingly done. The music is heart-wrenchingly beautiful and the dialogue is lovely, especially Kirk's last words.
"It was the least I could do... for the Captain of the Enterprise. It was fun.... oh, my..."