Phil Elverum from The Microphones and Mount Eerie lost his wife to cancer and then wrote an album about it called A Crow Looked at Me. It is absolutely heartbreaking. Here's the opener from the album.
There's plenty of sad songs in this thread but this is the "this isn't cathartic it's just devastating" kind of sad that can only come from real, deep, somber, visceral pain