Ever since Mario first defied every natural law of physics only to be told that the Princess was, in fact, actually chilling in some other dude's castle (and lol, sure she was), video games have absolutely reveled in the old rug pull. Friends become enemies, enemies become friends, the cake - of all things - is a lie, you've played them.
Traditionally the seeds of these things tend to be woven into the story from the very start and, sadly, once you've been around the block and/or assorted castles a few times you get fairly accustomed to spotting them. It's pretty rare that any title is able to hide an absolute gamechanger from you, let alone something that recontextualizes the entire narrative.
Rarer still though, is the whole idea of not revealing your biggest twists. Instead, going to lengths to insert them into the game but happily letting the majority of players ride through without ever spotting them. Whether that's having NPCs with astonishing but optional scenes, or just writing an entire subplot into a new character, shoving them into the background, and never mentioning them again.