Silent Hill 2 was the least scary of the whole series. Only Pyramid Head was scary, and that's because you can't kill him, and that he can approach you at unexpected times. Everything else didn't scare me at all. Not even the final boss, who was a pushover.
I would prefer the 1st, and 3rd Silent Hill games. And just to let you know I'm respectful of everyone's opinions including yours. But that's just my experience playing Silent Hill 2. For me it's still good, but just not that scary. (except for Pyramid Head)