Choosing from my favorite well-known artists ...
The Beatles -- Being For The Benefit Of Mr. Kite. Really a lot of Sgt. Pepper's is mediocre by their standard.
Rolling Stones -- Sympathy For The Devil. Overrated and ponderous. Also, to echo Buck, pretty much everything since Tattoo You. And there's a bunch of Stones' songs that I'd rather never hear again -- It's Only Rock 'n Roll, Miss You -- that aren't bad per se, but have been overplayed into the ground.
Led Zeppelin -- Whole Lotta Love. Stupid song that doesn't really "rock" at all. And the freak-out in the middle was probably horribly dated by about 1972 or so.
Bob Dylan -- Most of his early acoustic folk stuff. I know that may sound like the stupidest statement every made on music, but early Dylan just doesn't speak to me at all. From the mid 60s on is when I get on board.
The Who -- Magic Bus. Stupidest ****ing song ever. I don't think I've ever met anyone who likes this song.
Elton John -- Don't Let The Sun Go Down On Me. Hate it. Hate it. Hate it. George Michael's cover doesn't help. Hate the arrangement, hate the sentiment in the song, hate the way Elton sings it. Hate.
The Clash -- Janie Jones. Sounds like it's being sung by some death metal parody version of The Clash. I'm also cold on London Calling (the song, not the album which is outstanding).
And among artists I don't consider favorites ...
I'll say it. Most of Bruce Springsteen's catalog leaves me cold. I don't dislike Springsteen at all, I respect him, but he's just ... blah to me.
There's some really good ****. I really like pretty much everything I've ever heard from Darkness On The Edge Of Town, 10th Avenue Freeze-Out and some of his stuff since, but I don't listen to Springsteen and break into heavenly Hosannah's like many do. I don't really get him.