I agree that some people find it tedious when things are laid out like that. Though fetch quest and moving the goal posts I believe are in most stories when it comes down to it. Alien Isolation had basically the same "problem", but I never find that annoying. It's realistic, life is full of convoluted fetch quests, I find that as just a framework, an excuse for something to happen along the way. What happens along the way are the fun parts.
The first mission is very memorable IMO. Honestly, all of them are to me. The Montero mission is the only that's annoying. The part at the end level where you don't have your tracker, and loose the lights?! Tense, frustrating, but in a good way. But that's just my perspective, I like Alien games kicking my a*s.