No band, musician, or composer that I can think of nailed it consistently for any extended period of time. Perhaps the most recent example would be Beethoven and before that, Mozart. I don't care much for Mozart's somewhat fluffy, academic style, but it's hard to find a bad bit in the whole lot. Moreso than anything else in life, in music, I find the reward in risk-taking. So liking 30% of a band's output (and really finding true gems in only about 30% of that 30%) is part of the allure. The concept of great has no context without the concept of horrible, and music is the most accessible example of that to me.