The scariest part of Night-
The part that makes the other maps less scary is the fact that you have a reason to be there. Working with your friends to escape a prison, exploring an abandoned theatre, releasing Sam from that pyramid thing, all gave you a reason to continue on with the struggle.
Night, on the other hand-
No one knows who you are. Hell, you don't even know who you are. You don't know where you are, how you got there, or what you're even doing there. All you know is that it's the only thing slowing your imminent death by the few seconds it takes to rip a board off a window. It gives you the false sense of purpose to keep surviving even though there is no possible way out,
Of the Night of the Undeeeeeead.