I think a lot of it is whether you’re into that type of music. Also, a lot of successful artists had a great album or two, but also lots of dross.
Pink Floyd had two great albums, Dark Side of the Moon and Wish You Were Here. You have to be in the right state of relaxation to appreciate it though. Sitting there completely sober would not work for me. Their earlier stuff (the Sid Barrett years) is a bit tiresome. The later stuff (The Wall and The Final Cut) was Roger Waters letting his pretentious ego run amok. Best avoided.
Bruce Springsteen nailed the working class guys driving cars and chasing girls in Born to Run. If you’re not into that, you aren’t going to like his music. He has written an astonishing number of songs. A few of them are excellent, most of them average.
Bob Dylan is probably simultaneously the most overrated and most underrated musician ever. I like his early stuff. The haters who say he can’t sing don’t know what they’re talking about, but he also wrote an astonishing number of songs, most of which aren’t great.
Bands like the Spice Girls and Oasis aren’t in the same league. They’re catchy, but unoriginal.
The singer I really can’t stand is Billy Joel. He’s trying so hard to do the Springsteen working class guy thing, but it’s a nerdy middle class guy’s idea of what working class guys are like. He’s not a terrible singer, but his songs are just cliched rubbish.