TL:DR
The game is boring.
Don't waste your time, don't waste your money. Play Baldurs Gate 3 if you want an engaging rpg.

The game has some great moments but these are super rare.
The game is an illusion, you're not exploring a vast space or universe but rather just a one small limited fishbowl at a time, behind numerous loading screens and menu clicks.

Space flight is basic and lacks any nuance (just point the ship towards enemy). There is no atmospheric flight. Instead the SPACE flight is designed to feel like atmospheric flight which limits the freedom of the player. Power distribution system is pointless because you can easily just upgrade your ship, skills or crew for the space combat and not engage with it. Decorating your ship is pointless, everytime you change a module, like upgrading the engines, all the items (notebooks, plants etc) get transferred to ship inventory. No point to place cool items around your ship and make it your home.

FPS combat is almost the same as fallout 4. No unique weapons with interesting effects and everything is stat based. There is rarely an interesting combo or playstyle with guns. Melee combat is a joke. Spacemagic powers are just skyrim shouts and are extremely boring to acquire. I hate the glitter collecting in temples beyond words.

Quests and characters can have some great moments and interesting storylines. Though overall the writing is bland, meaningless and doesn't make the world believable.

I'm a sucker for space games but this is an utter dissapointment, i'm GENUINELY hurt, heartbroken and the minuscule amount of trust i had for Bethesda is gone.

There's a quest that illustrates this games shortcomings well.
A CEO of a shipbuilding company asks you to help his design team because they can't decide on a ship design. Perfect quest for a game with a shipbuilder, i thought. You go to the factory and need to talk to the annoying 5 person design team. Everyone has a different idea and you have to pick which one is good or bad. Then you have to do a super basic bounty and a passenger contract for "market research". Talk again with the dislikeable people and you're done. As a reward i got the ship but i couldn't fly it because my pilot skill was too low.
It's unfathomable how a game with shipbuilder doesn't use it in a quest where designing a ship is the main point. That whole mission could've been an email, but instead it was the player fast traveling and picking options in a meaningless dialogue.

There's so many parts of the game that work against eachother.
1000 planets to explore but all of it is boring procedural slop.
Huge universe to fly and run around but it's segmented with egregious amount of loading screens.
Lot of stuff to loot and sell but vendor credits, player and ship inventory are super limited.
Numerous food items with various effects but all of them are ridiculously underpowered.
Many characters to engage with but most of them are annoying and unlikeable.
Weapons with many different stats and legendary variants but enemy AI is so stupid that it doesn't matter (applies for space combat aswell).

Just a massive dissapointment on all levels.