I'm the same way. Even just going from the "lore" most planets aren't going to have colorful interesting cities in it with unique locations and things to do. A lot of the rocks are going to be desolate with nothing on it, because they should be. When you find something of interest in the desolate void of space, it's gonna be interesting. Every planet having the same formulaic procedurally shaped bar, merchant, and a fetch quest would have people foaming at the mouth about how Bethesda replaced their specific crafted environments with shitty generated ones with no soul.

I haven't played it yet (A second play through of BG3 sounds more appealing right now), but in general for an singleplayer RPG I would prefer a small full setting to an empty large one. If the environment has almost nothing of interest in it, then I'm going to just be glued to the objective marker, which while not a deal breaker, definitely hurts the experience. In a more curated environment I would ignore the objective marker and go off in a random direction. This means my experience is more unique and gives a proper sense of exploration which can make the game feel bigger even though it is technically smaller.