I think you are missing the forest because the trees are in the way. All stories need drama to make them work. Before you can get redemption, you need a moral or ethical quandary to battle against. Otherwise, the story isn’t so much a story as it is stuff that happens sequentially. So yes, the fun in the narrative is the positions you get put into and the things you have to overcome (at the very least, sub par plots) to get from point A to point B.
History (real history) is filled with these types of situations… where a charismatic leader says, “Do this for honor!” and the underlings happily execute the plan, but along the way, they start questioning that leader and his/her motives, then realize they’ve been on the wrong side (or the right side) of history, only to look for a path to redemption.
So not sure what narrative you’d want in an MMO that is so much different than whatever experiences that inspire the stories we tell over and over and over again in our creative works.