Geez, well, Big Daddies can be really scary, if you run out of ammo in the open.
Cheiftans from Halo 3 will scare the shit outta you if they jump out from around a corner. I've had that happen. I need to pause the game to recuperate.
If you mean like pure FEAR, as in, just the sight sends...