I'll start.
I think the lore's best whenever it is character driven, when there are many characters that have a history, interact with each other etc. When they 'surprise' us with tragic losses (Tirion/Varian/Vol'Jin) and when characters change. I feel like expansions like Cataclysm were absolute garbage because Deathwing was this guy that we never got to know or understand, same with Old Gods. These stories are shallow and weak.
Legion/Scourge/Alliance&Horde is where it's at if you ask me.
I think after this one if all they got left is the Void it will be a very bad time for those of us who like good stories. Azshara may be entertaining, but that's about it. But I'm very happy with the lore right now in Legion.