I've been a lurker at the threshold long enough. I figure it's time I crossed it and posted something.
The Silent Hill series is definitely my favorite video game series. I like all the games for different reasons. Silent Hill 2 is easily my top favorite, as it's the one I bought and played through first and it made my blood run cold pretty much right from the off. That said, one of the biggest scares that I received from any of the SH games was in SH3. The bit is closer to the end of the game, in the nightmare hospital, with the room that locks you in and you get to watch through the large mirror as the reflected room oozes up with blood, which finally leaks into your side of the room. I can remember frantically mashing my 'x' button against the door as I tried to get the thing to open.
It was just a room filling up with blood, but it was patiently slow, and relentless. Just watching it happen, I knew something nasty would happen if I didn't get my crap together and do something. I'm pretty sure someone mentioned this moment already, but I'll be damned if I didn't spatter my pants and take a long break from the game after that. That scene, more than almost any other, reminded me that for all the creepy, twitchy things you came across in Silent Hill, the town itself was a horror that was so much more absolute. Now, I've yet to get through Shattered Memories, but something tells me that I won't be spackling any more pairs of pantaloons to moments like that.
Anecdote time! I first played Shattered Memories when I went to go visit my Mum for New Year's. She and my Step Dad had just purchased a Wii for Christmas, so I brought my copy of Shattered Memories with me to show them. I hyped the game up, telling them about the psychoanalysis the game makes, and the changes to the gameplay that follow. So we all sat down to watch the game go on. The graphics were great, the controls weren't bad (having free reign of the flashlight had a lot of potential for comedy).
Now, my Mum is not a fan of horror. She's not cool with being scared, and when I'd played other Silent Hill games in the past she has, at times, asked me to turn them off. I was so looking forward to that happening again. I so wanted SHSM to be scary. It was certainly spooky, with the ghosts you can only see with the camera phone, and the tromp through the forest. But it wasn't scary. My Mum even laughed when the 'threat' appeared and said it looked like I was being dogpiled by really unattractive naked people (This did make me try to shake them off harder, mind you).
With the game being almost first-person like that, a slow, relentless threat like a room filling up with blood, would be terrifying. The 'trapped in the drowning car' sequence was leaning in the right direction, mind you. But if it was blood the car was filling with, I'd be out buying pants just now instead of wasting everyone's time with a long post like this one.
TL;DR: SHSM was fun and spooky, but not scary enough to scare my Mum.