@BitterlyIndifferent btw my favorite proposed solution would be to have no scripting at all. kinda like games like rimworld or dwarf fortress where you write the story yourself by interacting with the game's systems.
I guess dishonored does this a bit too; you get a "general goal" (kill some person maybe) but how you reach that goal is up to you, and most times, there's various ways to do it.
but I understand it's hard to combine having stuff like lore and pre-written stories with character speech and all that, with having more procedural, systems based gameplay. personally I prefer the latter