They are not inherently bad. I did quite a few in Skyrim but how they were introduced didn't bother me. First big city I was in windhelm or something I think. you can bump into a lady who is trying to become a trader and wantes training form the khajit, but to do so she has to present them with a gift of a mamoth skull. There is enough dialogue and story when speaking with her, where I am happy to say hey sure I'll keep my eye out for one.
Basically how the quest is presented is 90% of the battle, add 3 decent lines to tell me why i'm doing this and you are probably good. You add enough depth to the character and their background story for why they need the X item it seems like a reasonable quest. In a open world there can be enemies along the way so its not just picking up groceries at the citadel.
also given we likely are colonists setting up a new colony I can see lots of the quests being fetch quests as you kind of do need to fetch things to keep a colony going.