Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tearjerker: Dog Soldiers
Sarge's last moments, namely where he looks at the picture of his wife for the last time. Especially sad when you realize earlier in the movie he'd said the thought of never seeing her again is among the things that scare him the most.