Not a sweet spot.

Morrowind was amazing because it is a hand built world. Oblivion had the same core error as Starfield: an overreliance on procedural generation.

For Skyrim they did it right. Just the right amount of procedural generation with enough manual work that things worked out.

You can't overlook the modding scene either. Oblivion had a great mod community with a lot of people getting into it and cutting their teeth there. So when Skyrim came out they were experts and made a lot of amazing mods, particularly framework mods.

But almost all of them are done and gone or corrupted into paid mods(e.g. Elianora, Kinggath(FO4)). So Starfield will never get a good modding scene because the core modding community doesn't exist now.