The first and third albums are both really solid, I think.
Their other albums have their moments, but they're at their best when he's just writing songs and not trying to prove anything, which was only the case on those two. The Colour and the Shape was "Hey, look how diverse I can be!" the 4th one was "Hey, look how heavy/intense I can be" the fifth was split into two discs, one of which was also "look how heavy I can be!" "and the other was "look how soft I can be!" That basically continues on forever. But yeah, if you haven't heard There is Nothing Else to Lose, I very much preferred that one over the wildly overrated Colour and the Shape.
Also, like B.D. said, it'd not like he's been forgotten or anything. Foo Fighters are still really popular, he played on two Queens of the Stone Age albums and the Them Crooked Vultures album, one Killing Joke album, he made that Sound City documentary (which I haven't seen but got good reviews: https://en.wikipedia.org/wiki/Sound_City_