Elden Ring got the Game of the Year award for a reason. The narrative is somewhat minimalist and told in fragmented notes, not the type you would see in Mass Effect, for example, but it is there. The biggest points of the game are exploration and challenge, though.

My personal favorite is Citizen Sleeper. Also Signalis is pretty cool somewhat oldschool dreamy horror game.