(It's weird, when I tried to think of a serious answer, I realized that I don't really remember games for their story, only their gameplay. Genshin is one that I've felt had no right to have as good a story as it did for a waifu moneygrab of a game. Other standouts are any Old Blizzard games, and maybe Tales of Berseria.)
D
Deleted member 19066
It's been 20-odd years and I still remember scenes from the game.
The ongoing Arc words throughout the narrative: "What can change the nature of a man?"
and getting answered by the MC in the end, stitched a lot of the stories together in the game leaving a very strong impression.