I understand a lot of people are put off by the flavor text in battleship royal rumble, I'm on the other end of the spectrum. I like the ramped up intensity, extreme to the max options.
I once tried to watch Star Trek: Generations with my grandfather. He said the opening sequence was boring, and fast forwarded through the bottle float. That's what I think a good foundry mission does. Gives you what you're looking for without wasting your time.
Some of the space missions are tricky for me in my assault cruiser because the mission assumes a bit more mobility than I've got. If I'm supposed to flit between satellites in a system, and they're in a zig zag order, I get a bit frustrated.
Narratively, if I'm told five or six times who I am going to meet, I begin to disengage a bit and go into an F spam mentality. At that point, the author has lost me.
As to the flavor bit, sometimes the authors get a bit logorrheic while aiming for Picard.