Nightmare House (1 & 2)
http://nh2.wecreatestuff.com/

and for te record, doom 3 wasn't scary at all. half life 2 was more scary imo