Whereas I am also wary about No Man's Sky's eventual quality, I think it is the anti-EVE. People who want immersive, simulator-like space adventure, will stick to Elite and Star Citizen. Those who want a middle spot, get Rebel Galaxy of Void Expanse.NMS is coming out on PC as well. Although with space sims like Elite: Dangerous and Star Citizen doing so well I'm not sure how well a relatively "casual" space game like NMS will fare.
For the laid-back, casual space explorer, NMS will be ace.
Also, expect Horizons to sell gangbusters. Even if that game is mediocre, it will sell like hotcakes and Sony will advertise the shit out of it.