True, the Wall is a Roger Waters solo project in a lot of respects. But he at least had the wisdom to let Gilmour, who has a far better voice, sing on key songs like Hey You and Comfortably Numb. Waters lost all sense of proportion on The Final Cut. If an entire album of Roger Waters ranting sounds like something you might enjoy, absolutely pick it up. To a lot of others it was the sound of the end. David Gilmour came out very soon after the release to say he thought it blew (or words to that effect). I agree, for the most part.
If you want a good sample of what early Floyd sounded like, without wading through a lot of self-indulgent albums, Relics is a good one.