IMO it would be very worth the hype save for not having enough epic missions. Also, the NG+ system if you choose to fully upgrade all the powers is very repetitious with the same exact floating in zero G mini game every time you acquire a new power or higher level of one. To make matters worse, in roughly 7 NG+ runs I never once saw any of the different scenarios the devs said can occur, so everything felt the same each NG+ except for slightly different dialog from the main characters at the start because they no longer recognize you.
Ship building can be hard to understand at first, but once you do it is largely for convenience and aesthetics, meaning you can build a very capable ship just by doing simple modifications to one of two you get free in the game. In fact what many don't tell you is you have to spend a LONG time playing to amass what's required to build those elaborate ships. So while they may be more convenient as far as what you can do onboard, it is far from convenient acquiring what you need to build them.
That said, there ARE ways to setup automated resource farming stations on planets rich with resources you need, but they can stop working out of the blue, which requires you to rebuild that station. This is largely why I just used extra capacity suit perks and a companion to offload resources I mined personally at the nearby stores on Atlantis and elsewhere. I was even using quick tricks to steal high powered weapons and ammo, but still NG+ felt mundane.
It's a shame because the game had so much potential, but you can't make a game look like it has tons of content by offering mostly barren cookie cutter planets that take more time to fully research than they're worth, and a NG+ system that only really changes the amount and level of powers and suit tweaks. Many of the powers make you OP if leveling them up too far, and it's by no means a good replacement for more epic mission content. The poor powers and NG+ systems is why many avoid them.
Mind you, I played it mostly after launch on my previous spec, which wasn't nearly as robust as what I have now, with no HDR capability. I fired it up once or twice on my new spec, but honesty, the HDR is underwhelming, and even though it looked noticeably better overall graphically, with snappier movement due to better performance, I still was not compelled to keep playing it. It just gets stagnate at a point when you realize you've already experienced the best the game has to offer, which is not enough.
Going forward, if Bethesda really care about Starfield and want it to remain sustainable, they're going to have to address the common complaints like not being able to fly manually around planets or from planet to planet within a system, and having to deal with a ton of loading screens. NG+ also needs tweaking to be FAR more varied each playthrough, and as I said, they need to add more epic missions. What worries me about the latter is they might start charging for mission DLC packs.