Ok, I've put in about 200 hrs of No Man's Sky now, although I still have not finished the story line although I have progressed it farther.
The TLDR would be: The game as it currently is in 2023, is a fun sandbox, but gameplay value - especially if not on a sale - is going to mostly appeal to a certain type of player. Even if you are the type of player it would appeal to, over a lengthy interval it might start to feel a bit shallow vs. some other more concise/specialized sandboxy games. Overall for sandbox genre I'd give NMS something like ... 6.5/10. Maybe 7/10 at most.
Don't get me wrong, I am enjoying the game quite a lot, and it's great for mindless chill, exploring, self-goals/long semi-mindless mental distraction. The level of freedom is great. But outside of freedom to explore/look at quintrillions of procedural generated planets, everything else - bases, pets, settlements/fleets, all of that, feel more at an afterthought level. Probably a consequence of trying to please those who wanted more than system/planet exploration, but still make everything in the game not required.
-------------------------------
Re: Questing
---The quest side of the game for me is maybe a 3/10 at best. The quests are extremely repetitive - not surprising or anything - and generally consist of perform scans on planet or check galaxy map for markers, go to a new system, land on a planet, find/click something, repeat endlessly, pattern. All the main and larger side quests I've done still feel like tutorials, with rewards mostly being access to new structure/crafting blueprints or maybe some tech mods and maybe making you build/use the new thing as part of the quest. So if you've already bought/upgraded a lot on your own, they are an especially pointless/annoying grind.
---being someone not hugely into strong narrative arc games, I'm often fairly tolerant of shallow quest systems as long as they're short/quick. My tolerance for the ones in NMS is really low. One or two of them, so far, have made me want to turn the game off for the session, in annoyance/boredom. They are more dull - and at times, RNG-irritating - than killing 30 rats in the basement. Just me tho.
---if one is the type who wants to finish the story, I would recommend brand new players to follow it almost exclusively. Save the sandbox or side lore hunting, if you like the game enough, for after. At least then they wouldn't feel as pointless as putting them off until later.
---there are a lot of nitpicky UI, controls, npc menu, inventory menu complaints I could make but eh.