Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Current 93
"Sleep Has His House," a rather downcast List Song, concerning that which death itself renders meaningless. The studio version, on which it's the title track, is particularly hard-hitting, as it's lead up to by a very long harmonium drone that makes great use of Looped Lyrics.
The Inmost Light has a few doozies:
"The Bloodbells Chime," which states the Awful Truth that innocence, once lost, is irretrievable. David himself couldn't help but break down in tears during the sessions.
Current 93 and Nick Cave's cover of "All the Pretty Little Horses". The original itself is already heartbreaking when you learn its origin: it was traditionally sung by American slaves who were forced to care for their masters' children while neglecting their own (which is referenced in the song itself).
Shirley Collins' version of at the end of "The Starres are Marching Sadly Home," which is made all the more poignant by a slight, if disturbing, rewrite.
"The Beautiful Dancing Dust", off Black Ships Ate the Sky. It's a beautiful, calming, almost lullaby-like piece about suddenly ceasing to exist, coming right on the tail end of the ominous Chris and Cosey version of "Idumaea."
"The Seahorse Rears To Oblivion," a gloomy, introspective song regarding Tibet's beliefs on God, creation, and the end.