I wouldn't have chosen Subnautica as a good example of plot in a game. It's a single plot arc with absolutely no branches, no choices, and no variation. After you play through it once what is there to bring you back for another game?
At least with something like Mass Effect, or if you're old enough Knights of the Old Republic, your choices matter. Something you do early on can have a huge impact on how the game plays out. It's a kind of emergent behavior although I'd be the first to admit that it's far more difficult to create such a system by hand and damn near (but not quite) impossible to do it procedurally.
I've played through Skyrim enough times that my most recent character hasn't done a single quest that was actually built into the base game. There's a mod that gives you random quests from notice boards outside the taverns, some of which are either too easy or too difficult for a character of your level. Although these are also single plot-arcs the variation and prompting to tackle something incredibly difficult for your level is what keeps it interesting. I ended up killing a Mammoth while my character was level 16. A frikkin' Mammoth and I haven't even got my big-boy armour yet
View attachment 24309