Crimson Longinus
Legend
Trad hasn't cracked the code because it's impossible. You can't simultaneously experience a fantasy novel AND simultaneously have full agency to explore the setting.
Players who want to experience a story have to abandon some agency. Players who want full agency over exploration have to abandon the idea of an experienced plot structure.
Whilst I would not put it quite so starkly, you're definitely onto something here. I think the "story" that the latter approach produces is more like an historical account. It does not necessarily follow proper dramatic structure like a novel would. And I think to a lot of people that unpredictability is a feature; in this game we genuinely do not know whether the super spy will manage to stop the terrible plan of the mad villain, as this is not a film that needs to have the predictably triumphant ending. Then again, I think some editing and seeding the world with (somewhat implausible amount of) interesting elements and situations is needed to avoid the game becoming boring. Real history certainly is full of interesting events, but the history books tend to focus on them and skip the boring parts.