Shards of Solitude is definitely centered around its atmosphere and narrative rather than cheap action or constant scares. You can check out https://pinkcrow.net/horror-games/what-is-shards-of-solitude/ for a detailed breakdown of the mechanics, setting, and story before playing, but basically you spend your time exploring an eerie abandoned factory while dealing with a girl named Miyuki, whose personality shifts between calm and aggressive depending on what you do. The environment constantly reacts to your choices, and with multiple endings to unlock, the mystery of what happened to the place keeps you moving forward.