Second person is often used in character-based games but rarely used in stories. Why's that?
Both stories and games are immersive art forms, so why is second person associated with increased immersion in one, and not in the other?
In games
In games, the audience has agency. They can make choices, do things, and to some extent control the progress of the game.
So while the audience know they are not the character they play, the fact that they control the game makes second person 'you' seem like a natural point of view.
In stories
In linear stories, the audience has no control, so second person feels artificial and a little weird: the audience can feel the narrator has put them into the box of this character and now they're being driven around with no choice.
A second effect of this point of view is that there are fewer 'entities' involved—there is narrator and audience, and character has kind of merged into the audience, meaning there are only two people 'in the room' instead of three, which will feel closer in a way that can feel intimate, claustrophobic, reflective, or creepy depending how it is executed.
If there's any reason to use second person in story writing, it's perhaps to create a deliberately reflective, self-conscious state of mind in the reader.