I think the silent hill games were creepy. The first one was the scariest
All those japanese games like forbidden siren are good contenders as well.
I think the resident evil remake on the gamecube was the best game though. It looked the business and had a great atmosphere