There's a huge disjuncture between science fiction in visual media -- movies, TV, games -- and in print media. Aside from novelizations based on visual media, most print media science fiction I've read has distanced itself so far from "cowboy" science fiction that it's scarcely even satirized anymore.
One of the things that I've enjoyed about Elite: Dangerous, is that of all the space games I've played, it's done the best of making space exploration feel like exploration, with a set of skills involved and coherent gameplay. I have some criticisms of it, but fundamentally it works as enjoyable gameplay.
On the other hand, I was in the Colonia region recently, and it felt like a bit of a shock. I had only recently returned to playing ED, and the last time I was in a fully "inhabited" system was around three years ago. Anyway, the way human society is portrayed is deeply misanthropic and cynical, so much so that I was eager to leave as soon as I could.
From what I've seen of it, Star Citizen entirely lacks any of the exploration gameplay I'd be interested in. It's a bit ironic, in that I remember seeing a promotional video for a multi-crewed exploration ship in SC, then bought Space Engineers, designed ships inspired in part by that video, and ended up spending 2,000 hours in Space Engineers, over several years; towards the end of that, I got Elite: Dangerous, and have around 650 hours in it. I don't know if SC has implemented that exploration ship, but if they still only have one system, it sounds like there would be little or nothing to do with it.