I guess I'm the only one thinking "The Wall" movie was genius?
Anyway, the album "The Wall", IMHO, is one of the most important musical compositions ever were written. Pink Floyd really are living legends.
Beside albums that were already mentioned in this thread I have to say I also really like "The Division Bell" (yes, I know, it's without Waters, but IMHO it still is a great album) and the song "Coming back To Life".