I used to be very much into the story in video games, but at a certain point the overwhelming majority have become so generic and dull that I no longer bother. The biggest offenders are the ones who throw an insane amount of exposition at you before you even start playing. I remember one where I was pressing “A” furiously for minutes, with no way to skip, before anything even happened. I eventually quit the game and ended up returning it without experiencing any gameplay.
A great example of how to do this right is CrossCode. It throws you directly into the action and shows you “this is how the game is going to feel” from the get go. Then it pulls back and gives you the story and a tutorial before carrying on. It was super effective on me. Because in the first few minutes I immediately got a taste for what was to come and liked it, I became much more interested and patient in experiencing the story.