starfield is great fun if you're a gameplay/combat fag.
not so fun if you care about quests, dialogue, lore.
It took for me iirc 200 hours for it to get boring, that's mostly doing dungeons for xp and loot, farming mats, outpost building/crafting and exploring the galaxy. Didn't mess with the ship building.
When I did get around to doing quests I realized how pozzed it was and it just ruined the fun for me completely.
I am anticipating several mods to start a new playthru. Particularly I want to see more complex, procedurally generated dungeons, difficulty and survival mods and better items/crafting to expand the endgame, which was very lacking when I played.