Wow. I’m super impressed with all the suggestions here. I’ll add a few of my own that haven’t been mentioned yet.
Her Story - you query a police archive database for video clips, eventually revealing the plot. Kind of a mash between a murder mystery book with the pages out of order and Google. If you like it, check out Immortality
What Remains of Edith Finch - all you can do is walk around a very unusual house. The narrative reveals itself as you do so. That narrative is fantastical and heartbreaking and also very sweet.
Crawl - multiplayer game - you are all trying to escape a monster and trap filled dungeon. One of you is alive and the rest are spirits who can possess the monsters and traps. Any time a spirit kills the living player, they become the living player. Unique boss fight at the end where multiple spirits control parts of a huge boss monster.
Please consider WanderSong. It’s a small game and was made with so much love. Games can have a huge variety of plots and environments. But the vast majority of games, regardless of what they are about, are actually about victory. You’re a space dwarf mining for minerals, but the game is all about mastery and winning. You’re a dragon-kin with magic shouts, but every quest is about achieving a victory over a challenge. And so on.
I would say that WanderSong is not a game about victory. It’s a game about happiness. The character, the mechanics, the plot, the environments; they all serve first to explore the meaning of happiness. There’s nothing else quite like it. You can find it here.
I knew that I was going to enjoy A Short Hike before I played it. What I didn’t expect was how much I enjoyed it. There’s so much more there than I anticipated and some of it is really lovely.
I’ve been thinking about the disappearance of God games. I think they didn’t disappear, but they evolved so much that we don’t recognize them anymore.
I feel some moved into the direction that we now call “simulators”, like RimWorld, the Sims, Two Point Hospital, and more. In my mind, the big difference between the God games of old and those new games is that in the older games your role as the player was explicitly defined, where in the new games it’s not. In the old games, you were “playing the role of a god in that realm”. The new games don’t bother to tell you “who” you are in this setting. You’re just the player, get on with it, play the game.
I feel like other God games moved in the direction of top down colony builders, like Against the Storm or Frostpunk. And again, I think the big difference between those games and something like Populous is that your role as the player doesn’t have an explicit name in the game world. You’re not a “God”. But most of the rest of the trappings are there, I think.