Horror in roleplaying games most often involves elements of the supernatural, from vampires and vengeful spirits to unkillable boogeymen and tentacled creatures from another dimension.
Relatively less common, in my experience, are mudane, non-supernatural horrors. Off the top of my head, I can...