There is also Roger Water's (or if you want to really consider The Final Cut an actual Pink Floyd album, Pink Floyd's) Two Suns in the Sunset, which is about as literate and simultaneously as histrionic as one can get.