i have several thousand hours in SE. The game is very much a Sandbox, think Minecraft in space (with more complex blocks). If you dont enjoy making your own content you will probably find it a bit lackluster.
Though the game has an enormous amount of mods available to fill out anything missing from the base game (my personal recommendations are "scarce resources" and all the "modular encounters" plugins).