I have some points to make, i read your OP and heres what my thoughts and opinion on the matter.
- First, i definitely get you, in this time period of gaming we have a lot of gaming centered around telling a story through typical cinematics and dialogue exposition which makes it tiresome to experience for someone who is not into story driven games.
- Few years ago i was very into story driven games, and honestly i still like them but nowadays im growing a bit of dislike towards them because im getting tired of it and i am starting to appreciate level design, emergent gameplay and other methods of storytelling more.
- Dont take this personal but i think it is kind of moronic to equate and compare video game stories with films especially the top tier films with the likes of Scorsese who is considered top 10 director of all time material, thats nuts, if you keep going into games that are trying to tell a story through this medium with this kind of expectation you are bound to get disappointing all the time.
Story in games work differently, they work as a tool to immerse the player and connect you and the world they are trying to create through player agency and more immersive tools that you can control, if the game was 99% cutscenes then i would be totally behind your movies comparison but its not like this, i dont think anybody goes to games just for the story itself because if you only want the story and dont care about games then that person would be watching films, we have a lot of people like that in our daily life. So i disagree with the people who look at story driven games through this lens, some people even compare games with freaking classic literature lol, i met someone who was very angry that people liked Witcher 3 and said the story was bad because its not better than Shakespeare, Dickens and Tolstoy, lol. People think that just because you can read the best books of all time, then that means there is no need for you to read someone else story and enjoy a story in a different medium? ehh i dont really find that logical or entertaining at all.
- Story in games should serve as a motivation, it fills this void to give you a reason to care, a reason to do what you do, its not a bad addition, its certainly not the most important or the most valuable aspect to games since i stated earlier if its your most valuable thing then its better to look elsewhere although there are some exceptions and some games can be refreshing and pretty good.
So having a story is imo a good thing, it also doesnt need to be very good and deep, for it to be just there and to give me a reason to care and immerse myself is more than enough and job being done but that also brings me to the next point.
- Story in games should be judged based on the type of the game, a game that is trying to tell a story first should be judged on that, no matter how good the gameplay is, if you game is 80% story exposition through audiologs, lore or cutscenes or whatever then that story better be good, and good doesnt mean literally on par with Agatha Christie and Tolkien, it should be engaging and well written enough to serve as a video game story. Just in the same sense that your cutscenes should be good but again not literally on par with Kubrick, Nolan and Paul.T Anderson. Like a good well made cutscene is appreciated over a terrible one, a good coherent well written story is appreciated over a garbage one, depends on your personal criteria and standards.
Back to my point if the game is like 80% gameplay and 20% story, then it matters LESS how good the story is, but if the game is 20% gameplay and 80% story then it matter MORE.
I just finished Atomic Heart, and i think the gameplay is decent but the story was poor and in that game there's a lot of story, a lot of talking, a lot of audiologs and computer logs and monologue btw the robot and the main character, all this talk this means the story emphasis is big, there is a lot of story and attempt to make a story, so when the story sucks then that means the game takes a big hit, and my enjoyment of the game drastically goes down, despite its gameplay being good, but a game like Breath of the Wild which has good gameplay and like 80% of the time i was playing the game and the story is minimal and just an excuse to do shit, then it matter less how flawed it is.
I like story in games, a lot of my favorite games have engaging stories in them, i dont think having a story is a minus, even if the story is not literally better than War and Peace lmao.
So just having a story that feels engaging, meshes well with the world, makes me care about what is happening, is not written very terribly with awful plot threads and mistakes and characters that make me remember them and care for them, a worldbuilding that feels alive and has depth, entertaining dialogue which keeps me listening and sometimes makes me draw choice and consequences to see them shape the story and the world around me, that kind of story in games adds to the experience and i like it.
Obviously, a lot of games fail at this, because its not very easy to do, in case a game fails at this but without trying then its fine as long as it falls on other aspects that can make up for it, but if a game is trying to go for that and it fails then thats a bad game in my book.