I think the staleness comes from the fact that it’s the 60 billionth time you’ve done some “quest” to go gather some crap up or kill the same thing in a loop for an hour.
No amount of dialogue is going to save that.
The actual story dialogue is usually interesting enough already
It’s so funny to reference a game that has like 12 editions and is on every platform including a refrigerator and think “this game is missing something”
By the way there are LLM dialog mods for Skyrim and everyone thinks they’re a joke because they suck.