Not games with a convoluted mysterious story, per se, but if it’s something that re-contextualizes the story somehow, that’s the kind of thing I’m interested in.
Inspired by my digging into the FF:06:5B mystery in my current playthrough of Cyberpunk. There are all sorts of weird codes and ciphers, bizarre rituals you have to do at certain places and times, and vague clues in weird places. One clue was even in an update to The Witcher 3, apparently. Based on my reading, the community found a sort of conclusion to this one, but it really doesn’t clearly explain things (though it fairly strongly hints at Night City 2077 being a simulation, and us not really playing V, but rather whoever is breaching the system at the title screen).
Random weirdness that leads to wild speculation is always fun. Sometimes I’d like it to stay that way rather than an acknowledgement and a terrible semi-explanation.
Example : Anna from Fire Emblem. She’s everywhere, on every continent, in every time period. She’s often the generic item shopkeeper, sometimes she’s in a relationship with some minor character… And sometimes she’s managing your game’s save data or hosting the tutorial, with absolutely no respect for the fourth wall.
It’s weird, and it was more fun when it was never mentioned, like who or what is that girl, anyway?
Then Fire Emblem Awakening makes her playable, and basically, she’s telling you. “Yeah, I travel through dimensions, and I have an infinity of identical sisters all called Anna. We’re all traders, so sometimes we even compete for a specific market.” There’s a freaking side quest where you have to fight a bunch of Annas for this very reason.
Fire Emblem Warriors, following on that, has the multiple Annas used as a joke and makes her ubiquity the central trait of her whole character (in line with the very Awakening-like trend of making characters have one cringey character trait mentioned every second and absolutely nothing else to them).
I think it sucks.