I don't mean to offend you by saying this, but I have no idea what "oh shit" moment you are talking about. I didn't experience anything in any of the missions that I would've considered an "oh shit" moment. I was more surprised that they changed the layout of the vex area at the top of the teleporter in the citadel from the way it was when I glitches into it 5 months ago.