Half-Life 1, no, not at all. Maybe it's because of slightly cartoony, comic-book art style(and it's a fast-paced shooter), it's very atmospheric with its ambience but not spooky. Running around in empty maps makes you feel lonely(obviously) and nostalgic.
Source, on the other hand, gives me this subtle feeling of dread. I think one of the reasons for that is slower movement speed. I always feel like I am tied to the ground, like in a dream where you can't run without stumbling. If something is chasing me, I won't make it. This causes paranoia.
Also, the art style is different. Textures and lighting are realistic, it's uncanny. HL2 is eerie already, but remove the combat or everything that distracts you and all that's left is a corpse pretending to be alive.
I'm afraid to play The Stanley Parable because of this shit.