Nightmare House 2
Wow... I was not expecting a mere mod of
Half-Life 2: Episode 2 to be this freaking good. This is easily one of the scariest games I've played and has some truly memorable sequences that put a lot of the more recent survival "horror" games to shame. In fact, this game does what the
F.E.A.R series has failed to do for three games. A few of the horror sequences do repeat themselves and there's one that's copied straight from
Condemned: Criminal Origins but little homage aside the game really does manage to create some creepy, disturbing, and immersive moments. If you have HL2: E2 installed on your computer and you want to play something that will actually scare you, definitely give this game a try. You can download it for free, here.
Nightmare House 2
My hat's off to you WeCreateStuff.