The plot of one of my favourite games, Outer Wilds (not to be confused with Outer Worlds), is about being stuck in a solar system where you die (avoiding spoilers intentionally) every 20 minutes and you have to figure out why.
One of my favourite games, the sense of mystery and the high stakes of the plot made it very intriguing to me.
Yep, it's the basis of Outer Wilds, one of the best video games of the last decade, but also others like:
-Sexy Brutale
-Life is Strange
-The Forgotten City (still playing this one)
-Twelve Minutes
There's also Return of the Obra Djinn which is a reverse-mystery thriller, in which you piece together what happened to a ship in reverse murder order.
One of my favourite games, the sense of mystery and the high stakes of the plot made it very intriguing to me.