One that comes to mind is Def Leppard's Hysteria following up Pyromania. It can be argued that Pyromania wasn't any kind of great album, but it was undeniably a classic of the genre, and Hysteria was just painfully boring (yet somehow sold a bajillion copies.)
And since I am referencing rock albums from my distant youth, I will mention that Empire was a huge disappointment following Queensryche's Operation:Mindcrime*. The best description I came up with for Empire was "steaming pile of monkey dung."
*I'm pretty sure I just outed myself as a lover of cheesy rock back in the day. Whatever, don't judge me.