The 1988-1992 period is damn fine, IMO. Sure, as BD says, Rape & Honey sounds pretty dated and primitive today, but I can still hear it back in it's day, so I can live with that. Mind and Psalm 69 are the band's two best albums, IMO (that I've heard). Psalm 69 may have been *too* good - the band spun their wheels for almost a decade after it (Filth Pig (1996) and Dark Side of the Spoon (1999)) with no apparent clue what they were supposed to be next. I gave up on them and have not heard any of their 2003-present albums of which there are six, according to Wikipedia.
The first five albums (1996-2000) range from very good to excellent. As I said once in the late 1990s, they're the band that put the "rock" in post-rock. I still play those albums and still get plenty of mileage. The later albums are not as good, IMO, but that's also partly due my opinion of their changing influences. For most of the 2000s they dicked around a lot with digitized '80s keyboard sounds and while the overall music quality suffered for it, the musical jokes did get funnier.
I haven't heard everything they released, and much of what I did never stuck with me, but I do have a strong attachment to Wrong (1989). The End of All Things has a section that sounds as if it could possibly have been cribbed from Baba O'Reilly, to wondrous effect.
Manic Street Preachers
I heard their three big albums (Generation Terrorists, Holy Bible, Everything must Go) back in the years of their release and none of it took. Too British, maybe. I played them all back when I was doing my revisiting of the '90s and liked them more, especially the latter two. Still haven't played enough to have formed a lasting opinion.
Case subject for if a career of releasing B+ albums makes you an A-minus band. The answer is "maybe."
A well-chosen compilation could be for 2000s indie what Steve Miller's Greatest Hits was for classic rock.
The fusion band without an electric guitar. Even Soft Machine eventually got one. IMO they had a special early period, a strong middle period and were decent enough in the late '70s once they achieved the fusion degree of stardom.
De La Soul
Not just the first album, but the first three are awesome. The later ones are pretty good too, in an inconsequential sort of way, as they were already sounding dated by the mid-1990s with hip-hop got tougher and funkier.