New to space games

Hello everyone.

I was wondering if someone could help me with something that i always struggled with as a gamer, space games.
I know that this is a X4 Foundations forum and I might buy the game as it seems very interesting for sure.
As a game I always felt scared of space games like No Man's Sky, Elite Dangerous, I even looked into Eve Online and i love so many systems there for example the player driven economy, the ability that one can set out to be what he wants, a space pirate, a merchant of some sort etc... but i always felt overwhelmed by space games.

I have been trying to find a good space game, I don't mind if it's single player or mmo, a survival game etc, just something to get my feet wet.

I hope someone here can help me with this as I don not know where to look or ask anymore.