I found the Exile's Reach story intro to be more compelling than just about any Shadowlands stories outside of maybe Revendreth. Exile's Reach feels grounded and relatable. You're a soldier with a small makeshift camp, rallying some allies and scouting the zone. You then deal with an Ogre problem and uncover some use of necromancy that ends in a fight with a dragon. The whole time I got that old school DND adventure vibe and enjoyed it quite a bit.
When you do something like Shadowlands, the story deals with eternity, ghost people, civilizations that persist in the afterlife on these pocket dimension islands... hard to really give a shit tbh. I like vampire stuff so Revendreth was enjoyable, but everything else is so out there it feels like background noise.
We need to get back to MoP style storytelling imo.