Since you believe that dissonance between story and gameplay is inevitable. Should games just abandon storytelling?
No, we just shouldn’t care so much about dissonance or the limitations that stories and settings place upon games. We should be free to come up with whatever gameplay mechanics we want to, whatever level structure we want to, without tying it back to consistency with a story, without worrying about it seeming “too videogamey”, without contrivance being disdained so much. We should stop complaining about all this “it doesn’t really work that way” bullshit when we know damn well that there’s a good reason for it and we wouldn’t have a game without it. Like all the complaints about the shrine of Winter. Like someone thinking, “oh, it’s dumb that samus loses her powerups every game, in Other M, lets have them be authorized at specific points in the story instead”
Game constructs are totally made up. They don’t have to relate to anything. We aren’t bound by physical laws when making them like we would be in conventional engineering. We might as well accept that and use it to our benefit.
But should we get rid of stories completely? I don’t think we should do that either. I certainly think we shouldn’t invest as major development resources into them, but they have practical benefits in the form of setting up mental relationships between different objects in the setting, being an inspiration for systems of play, and guiding the player goal-wise. That and like music and graphics, it’s a tangential benefit to the work as a whole.
We just need to stop viewing storytelling as the reason for the medium to exist, since that’s not going to happen.