Seriously there is a HL2 mod called Get a Life (blame the French for the name). What I read about it sounded very nice. It has a story new weapons and characters sounds like a decent horror single player mod.
Haven't tried it yet but thought I would share it with you.
http://www.moddb.com/mods/6032/get-a-life
Haven't tried it yet but thought I would share it with you.
http://www.moddb.com/mods/6032/get-a-life