I just thought of one that's more like "Moments that made you quiver with fear":
In the nebula mission (SM2-02: A Game of TAG) when Kappa 3 shows up:
Mayday! Mayday! This is Kappa 3 of the 107th Ravens, GTD Aquitaine! Command, do you copy?
Command, get the fleet out of the nebula! Shut down the portal now! There's no time to lose!
Listen to me! There's no way we can stop them this time! Shut down the portal before it's too late! There's something out there, Command! Please!
When I first played that, I just wanted to get out of that nebula, go back home, maybe fight some NTF baddies and just forget all about the Shivans.