This is all opinion based but there are very few bands that have entire excellent body of works.
Example: the entire Police catalog, the entire David Lee Roth Van Halen catalog are two that come off the top of my head. These are bands where I could go through their entire catalog (4 or 5 albums each?) and never skip one song. It’s harder to do that with bands that had 8+ albums. Yeah some of the songs aren’t flawless but I’m still not skipping them.
There are several bands that had 1 or 2 excellent albums where the producer and the band just came together, and out of 10 tracks 8 of them could have been radio hits, I would imagine a couple of guys got together and narrowed the songs down do radio airplay popularity. Sometimes they got it right, sometimes they got it wrong.
Some of my favorites that I view as virtually flawless:
Living Colour - Vivid
Nine Inch Nails - Pretty Hate Machine
Jay-Z - Reasonable Doubt
Robert Plant & Alison Krauss - Raising Sand
Most people would say - Nirvana - Nevermind or a certain AC/DC or Stones or Pearl Jam album.
Now the rest… there are a lot of good bands out there that have several bad albums. A lot of this I feel came from record contract obligations or easy money grabs. A lot of my favorite bands have more shitty songs than good songs when you look at their body of work. The good songs are so good, and the bad ones are really bad. Not really any different than a professional athlete having a great game, only to drop a goose egg the next week.
People worthy of being on this list:
Red Hot Chili Peppers
Metallica
Aerosmith
ZZ Top
… just to name a few
Looks at these bands - so many flawless songs, but also, so much garbage in between too.