All right, the closest I've seen to decent music in this thread is "More than Words" (hardly Extreme's best) and that's pretty sad!
Fates Warning--Still Remains: About the death of guitarist Jim Matheos' father. Powerful stuff...
Iced Earth--Watching Over Me
Faster Pussycat--House of Pain: C'mon, some of you older kids must remember this one.

Great video, too.
Metal Church--Little Boy
Ark--Missing You
Dream Theater--The entire SFAM album, but especially "Finally Free" where you find out what
really happened, and Julian and Victoria die in each others' arms. (sniff

)
Threshold--Angels: How could I almost forget this? It's from a concept album about a guy who's genetically engineered to be superintelligent (among other things) and this track is about how as a young adult, his mother has shied away from him and won't talk to him anymore.
--T.J.