The epitome of what I’m trying to refer to is the Playdead games (Limbo and Inside). Dark Souls and BioShock both hit on this idea but not quite so directly. The game BADLAND is also a great example of this, too. The mobile game The Silent Age also did this exceptionally well. Never quite knowing what’s going on, and maybe some tension without release, but again not straight up horror. A feeling of uneasiness is what I’m looking for.
When playing through Inside, there’s never any moments where you’re scared, but you’re never sure what’s going on and there’s always a level of unease. What are all the mindless zombie-like people? Why is everyone hunting the player? What happened to this city? What’s the goal of the character the player controls? What exactly is going on here? That’s what I’m looking for. If you know of any other games which do this, I’d greatly appreciate hearing about them. It’s a very specific niche so I’m not sure how many games do this, but the games that I’ve seen do this tend to be some form of post-disaster or dystopia. I’ve seen some great artwork do this too. Zdzisław Beksiński had done some stuff like this. Some great dystopian novels also do this quite well.
Segments of most 3d Zeldas are like this, but the one that takes the cake is definitely Majora's Mask. The entire game is like one bad dream.
Most Metroid games also qualify, which makes sense since they draw heavily from the Alien movies.
Seconding basically all the (mainline) Metroid games.
If only the Zelda games were on pc :( I could emulate though
I’ll look more into Metroid too