left 4 dead 2?seriously , that game is more fun than scary , shooting zombies etc. not scary at all
as for silent hill , well that game is quite scary , depends on what silent hill ( 1,2,3) , didn't play most of them so i'll go only with the one i played ,shattered memories,penumbra is also scary , i heard, didn't play it though.