Here is an essay on the concept of “ludonarrative dissonance” in games that I found very interesting: http://www.fredericseraphine.com/index.php/2016/09/02/ludonarrative-dissonance-is-storytelling-about-reaching-harmony/
I guess this really bothers a lot of people. Ironically, I feel most of the games that have really impacted me have deliberately featured this dissonance and made it part of the experience, rather than trying to avoid it.
In some ways though, I don’t even get why this bothers people. A gap between what I am trying/want to do and what I can/must do IRL pretty much is the essence of my normal human experience. Life, at its core, features this “dissonance.” When it features in games, to me it actually makes them more lifelike.