The John Carpenter movie "In the Mouth of Madness" is still one of my favorites, and I think, an overlooked gem of good horror with a solid balance of monsters and psychological stuff.

That said, after playing through Silent Hill 2, most horror movies just aren't scary any more.