To give an impression of what it’s been like for me:
I had a quest where I needed Iron. I found a random planet that had it, and picked a spot in the middle of the scan readouts. Arrive, looks like a barren rock - but that’s fine because I only wanted rocks. However, I see something in the distance, and check it out. On the way, I find a wandering trader taking her alien dog for a walk, and sell some stuff weighing me down. I find a cave, where a colonist is hiding out with a respiratory infection - and am able to help them get out as a little mini-quest, though the infection spreads to me.
I come past a little mining installation, where I find a bounty hunter that tells me of a bounty nearby she’s offering to split with me. We do so, fighting a base full of raiders to get to their captain, and I finally decide to leave.
The key here is, I don’t think any of those quests are amazing - they’re likely very dynamically generated. But they’re also not fun to “seek them out” - just to come across them in some other mission, like trying to make an outpost or mining for stuff.