I do like Dragonflight, even though I have my gripes with certain things! As I said earlier - and what Meronspell disagreed with pretty hard - was that Dragonflight has been a return to the more grounded storytelling that you found in earlier Warcraft times, such as Vanilla. And playing SoD, I’m pretty much reaffirmed in my statement.
If anything, you have more of the story told in Dragonflight (because you have a main story quest and you only have 10 levels), because unlike in SoD or Classic, you also do the main story quest with more stakes and more important NPCs both allied and enemy in addition to helping the locals with local problems, both reactive and not to current expansion problems.
I simply started playing SoD after I posted to do Blackfathom Deeps (beat Aku’mai woo!) and maybe it’s the 'tism or whatnot, but I didn’t register as anything getting heated or whatnot. Maybe my sentences started getting clipped as I realised ‘oh crap I need to hurry up’ so tone-clarifying words were probably omitted, sorry.
Bottom line - I feel like Dragonflight has been far more of a return to ‘Warcraft’ feel that the GD bottomfeeders have been crying for, than like past 4 expansions have been, despite the Disney-fied story resolutions at times. Personally, I found myself caring a whole lot more about the local NPCs than anyone in Shadowlands, BfA zones, and even Legion. I found myself reading the quest texts far more often because I was interested in finding out more about the NPCs, especially when I would clock ‘oh look, representation, yay!’
Many of the NPCs had a similar peppy tone which could get grating over time, but…WoW has had a problem of pretty much everyone having the same tone all the time anyway, whether peppy or melodramatically serious, and only occasionally would it be juxtaposted with the opposites (f.e. the Ardenweald butterfly people and everything else being SUPER BLEAK, dryads in Legion etc).
The only NPC ironically that I didn’t really care about was the old dwarf in Ruby Shrine place who everyone else liked, because he was just waffling on about his wife or something and I couldn’t skip the text.