I’ll partially answer your question as well - by reference to this proposal:
https://us.forums.blizzard.com/en/wow/t/writing-a-pvp-narrative-post-shadowlands/801368
The thing that I want to note is - there are no major changes. The content is built up around, and supports battlegrounds - which I think should be the gameplay equivalent for these narratives as dungeons and raids are. Those are where you should find your power fantasies, if you’re good enough to get them.