This sort of thing is why I still play videogames.
One of the ages in the Path of the Shell expansion for Uru has at least three good stomach-drop moments in it. It’s the one where you start off on an island with a bunch of crabs.
[spoiler]If you chase all the crabs off the island and reload the level you end up on a blasted version of the island where all the water is gone and there are blue crystal pillars sticking up everywhere. Destroying all the pillars and reloading (which is really tedious by the way and involves running around the island counter-clockwise and warping to a hallway with a linking book back to the island) puts you an a similarly shaped island/asteroid floating in outer space. So that’s eerie.
But then if you do a lot of Myst-puzzling involving switching back and forth between the three island states (agony) you can turn off the water current in the first island and swim off into the distance where you find that the billboard islands in the distance are diegetic billboards and these are Truman show domes you’ve been in. You swim outside the dome into the boiler room area, do a bunch more switching back and forth, and find yourself, perhaps even unexpectedly if you’ve been brute-forcing the puzzles as I had, in a fourth unfinished dome containing a huge statue surrounded by scaffolding. [/spoiler] It is the best and the worst Myst age at the same time.
Besides that, Pathologic is good for this. Also Kairo, STALKER, Kitty Horrorshow’s games, seconding La La Land, and Metroid 2 on an original gameboy when you’re in the hospital having almost died from a ruptured appendix.