Oh boy, where to start? There are *so many* video games about space I'm going to ask you to be more precise.

Off the top of my head, if you safely want to:
- Build stuff in space: Starbase (Early Access), Astroneer (2016), Space Engineers (2019). All are geared towards cooperative and creative multiplayer.
- Shoot pirates and aliens, smuggle contraband, upgrade ship: Rogue Galaxy (2005), Galaxy on Fire 2 (2012), Freelancer (2003).
- Be immersed in a real spacefaring simulation: X4: Foundations (2018), Elite Dangerous (2014)
- Wander between wondrous and weird worlds: No Man's Sky (2016)

My main problem with EVE Online is that it isn't very forgiving. The main takeaway from the tutorial is "Don't fly what you can't afford to replace". Now, this also makes the game extremely interesting to play, with a whole player-to-player economy depending on aggregate demand for any of the myriad of merchandise that can be produced, sold and consumed for various endeavors. Ultimately, it still is about building armies of expensive ships and fight other players, and it makes me extremely nervous.

Single player is better for me, I'm enjoying more control over the game pace and I can reload in case of a massive setback.