I think Dragonflight is the most memorable expansion since Legion.
DF story and zone design was a steaming pile, no wonder you feel this way. There weren’t any stand out elements that can be seen as good aside from professions and some reductions to grind. The raids also had very few enjoyable bosses.
DF definitely stands out as the worst expac I’ve played.
Meh I’ve rarely paid any attention to actual story line in any expansion. DF, for me, was one of my favorite expansions. Id rate it next to wotlk for sure. Aside from the obvious, there’s dragons, I could care a less about the story line as long as it’s fun.
There was that one quest where that NPC sits on the ledge and tells you a story. That is the one cool thing about DF but honestly I liked the story telling of the NPCs in WoD far more though as you advanced on your questing journey.