We must be playing different games. Every storyline quest I've done has been:
- Go to this random place
- Gun down everyone in sight because my mandatory companion can't stealth.
- Talk to the named bad guy.
- See if I win a coin flip. 4a. Walk out with a McGuffin. 4b. Gun everyone down again, then walk out with the McGuffin.
It's nothing but, "Go there, kill guys," as you call it. Everything is a fetch quest with faceless mooks between me and whatever fifth turn I need to take to get to the end of the corridors in the space dungeon.
And comparing the game to Morrowind is laughable. Morrowind was an amazing feat of world building based on actual player choice. Starfield is a bunch of boxes to tick to see the next space cliche.