I found System Shock 2 scary for the same reason I found EO scary.
You're constantly worried about your inventory, since it's so limited.
Often I'd be wandering around with only a few shots left, and I'd have to make careful decisions about running from enemies or using up the last of my ammo and hoping I'd find more.
That and the sound design is great.
I'll tear out your spine...