Are sad and beatiful songs qualified? If so, I've got a whole bunch, as I love that kind of stuff!
The only metal song I can come up with at the moment is Type O Negative's "Bloody kisses (a death in the family)". I see that Stoner Sioux mentioned "Everything Dies", "Everyone I Love Is Dead" & "Red Water", but I don't think they're anywhere near as depressing as "Bloody kisses (a death in the family)". I'm also a major fan of theirs!
Let me know if the sad & beautiful stuff qualifies!