Hot take: WoW never had a good story in any expansion. Just a few good moments scattered around like islands in a sea of grind.
The closest they got to a good cohesive story was Legion, but that was only if you were playing from the beginning and got to see everything develop live before they just started shoving people into catch up points that made no sense without context.