Pink Floyd "The Final Cut"
Depressing yes, and simply not good music wise either; I don't think anyone would object to this being called the worst Floyd album, and least from a 'music' perspective.
But you need to hear Lou Reed- Magic & Loss.
Album is about a couple of his friends dying from cancer; depressing? Yes, but at the same time, great album, one of his best.