These are what we call the 'YMMV items.' Things that some people find in this work. We call them 'your mileage might vary' because not everyone sees these things in the same way. This starts discussions in the trope lists, a thing we don't want. Please use the discussion page if you'd like to discuss any of these items.
Badass Decay: The Gunboats, the first one you meet looks terrifying, then destroying them becomes routine.
Crowning Moment Of Awesome: Blowing up the Nanosoft capital ship from the inside, then hauling ass out of the massive ship as it explodes around you.
Nightmare Fuel: Did anyone else find that in the mission Where you need to breach that dome with the Cruiser in and realizing you were outnumbered, outgunned and with the traitor Ricardo bearing down on you to be utterly terrifying?
Not terrifying, but this troper agrees it's one of the more difficult missions; persoanlly, that Gunboat with the BFG's in mission 10 was the Nightmare fuel, until you learn to just sit back and lob missiles at it, reload, repeat, job done.