I like A Momentary Lapse of Reason, but my favorite album by them is Wish You Were Here.
Some other favorites, no particular order:
Pink Floyd - Dark Side of the Moon
Radiohead - Ok Computer
Daft Punk - Homework
BIlly Joel - Piano Man
Edit: Sorry, I didn't make it clear, my #1 favorite album is Pink Floyd - Wish You Were Here.