Queen - '39
I know it makes no sense that my favorite Queen song is not sung by the GOAT (Greatest Of All Time for all you kids out there) but here we are.
I'd agree with you there. In fact, I hate the vids where Freddie is singing this. I loved Queen's earlier stuff, but generally liked May's and Taylor's compositions more than Mercury's. My three favorite songs on ADATR are two by May, ('39 and Tie Your Mother Down), and Taylor's lone entry (Drowse). I found Mercury's stuff overly campy. That was the last Queen album I enjoyed listening to.
Most of the music I've listened to the past 30 years has not been by bands that BY would probably call "great". But these would be my choices off top of my head:
Kinks: Waterloo Sunset (not obscure in any part of the world except the US) and Rats
Waterboys: The Pan Within, A Life of Sundays
Bowie: All the Madmen
Alice Cooper: Ballad of Dwight Fry, Big Apple Dreamin' (Hippo)
Radiohead: Electioneering (really doesn't fit at all on OK Computer, but a great song)
Led Zep: Ten Years Gone
Replacements: Red Red Wine (IMO, the last pure slopfest the Mats put on vinyl as they were trying to go more commercial)