It's not a scary game really, most of it has a dark humor to it.
Some moments in dark corridors it can get a bit unnerving. When your pip-boy says there's an enemy near by, but you can't quite see him. And then you sneak ever so slower, slowly edging round the corner. And when you finally pluck up the courage to look round, a ghoul is kneeling down eating a corpse of another fallen adventurer. He looks up, and you realize that it's too late to un-holster your weapon. You're screwed.
But yeah, other than that, ;D