My fave albums are Let it Bleed, Sticky Fingers, Black and Blue (which I hated at the time, but it has aged well), Some Girls, Tattoo You and Vodoo Lounge. Steel Wheels wasn't bad either, but then it came after two comparatively weak albums so anything would have been a relief.
Goatshead Soup was varied, you can say that for it. Rambling in places, but varied. And it contains with Star Star the best Chuck Berry song Chuck didn't write! It epitomizes Stones rock'n'roll to me and admittedly nobody does that type of music better.
I believe the only Rolling Stones album that I've never heard front to back is It's Only Rock'n'Roll, somehow that fell through all cracks with me!
Frankly, I don't think the Stones ever recorded anything approaching Magical Mystery Tour. But if the songs from Sgt. Pepper and Magical Mystery Tour (the album, not the EP) had been a double album, then no other band could have ever matched that either. And this is coming from a card carrying DP fan.