Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Master and Commander
As HMS Surprise is rounding Cape Horn, one of the seaman Wharley is washed overboard whilst trying to secure a flapping sail to one of the masts. As he swims towards the wreckage of the mast, still attached to the ship by it's rigging, it is revealed that the wreckage is pulling the ship under, threatening to sink her and kill all her crew. The Captain Aubrey must make the decision to cut the ropes and sacrifice Wharley to save the ship, doing so along with the Ship's Master, and also Wharley's best friend Nagle. As Jack cuts the last rope and the wreckage floats free, we see Wharley, still swimming, disappear behind a large wave. This is accompanies by Vaughan Williams "Fantasia on a Theme", and made even more powerful as the scene cuts to the rest of the crew below decks celebrating their survival, oblivious to Wharley's death. We then see Nagle sorting Wharley's possessions and shutting them in his sea chest, including a sketch he had done for his sweetheart with the words "Home Again".
The aftermath of the final battle is also a tearjerker (with Vaughan Williams again contributing). We see the dead lined up on the deck being sown into their hammocks, including Nagle, and also teenage Midshipman Calamy, just promoted to Acting Lieutenant. As is tradition, they are sown into their Hammocks by their messmates, and Calamy's friend and fellow Midshipman, 12 year old Blakeny looks on, before asking if he can do the final stitches. Having lost his arm earlier, he is unable to, and needs help from "Awkward Davis", a large, dangerous brute, but incredibly loyal to his Captain, who does so without words. We then get the funeral service, where Aubrey (played by Russell Crowe) reads out the names of the dead, stumbling slightly at the ships Sailing Master, Allen, then choking as he reads out "Peter Miles Calamy, Lieutenant".
Hollom's entire character arc, from being still a midshipman at nearly thirty, to coming to believe he is a Jonah thanks to his treatment at the hands of the men, to killing himself.
The suicide scene. And his choice to let it be witnessed by the one person, the one twelve-year-old boy who's been nice to him, and saying goodbye...
Any time Ralph Vaughn Williams' beautifully mournful "Fantasia on a Theme by Thomas Tallis" kicks up, expect waterworks.