Stories are probably the most important aspect of a game for most genres. It can supersede visuals and sometimes even gameplay if it’s good enough. Sadly, great stories in-game are hard to come by these days. Memorable characters, interesting twists, and turns, and a fantastical world packed full of lore. There are many ways to tell a story either through text, visuals, or voice acting.
Alan Wake II
Alan Wake II‘s story isn’t just more comprehensible this time around, but feels so unique and different from many other video game stories out there. The mix between live action cut-scenes, the voice acting, the narrative direction, and the overall production values just add up to one fantastic story that lets you catch new things or details you missed with each play through.
Runner-Ups
Mortal Kombat 1
Hogwarts Legacy
Final Fantasy XVI
The Cosmic Wheel Sisterhood
thebinarymessiah.com 
Yep! The fact that I forgot about this game until you made a comment proves that.