You may like Dementium: The Ward. I picked up a copy of it on sale for 12 bucks, normally its about 20 - tho I've seen cheaper used ones on Ebay.
I haven't completed it yet, but its a first-person-shooter kind of game where you wake up in an abandoned mad house and piece together clues as to why you're there. You encounter zombies and other creatures, including hordes of flesh eating roaches and creepy ghosts in the children's wing.. It's pretty fun. 
(i've run across a lot of videos of the game play in youtube - just search for "dementium the ward ds")
Yes! Thanks for reminding me about it. Surprisingly to me, IGN gave it a really good rating..it definitely looks worthwhile.
Aww, come on. The Silent Hill games are scary, regardless of how you feel about the movie. But yes, Resident Evil is scary shit. Fatal Frame is kinda scary too. There is a 360 game where you play as a Native American that has to fight aliens, and at certain points in the game, you actually listen to Art Bell broadcasts. Deus Ex games are pretty cool too.
1. The only good thing about the Silent Hill movie was that Pyramid Head was in it. Other than that, as a true fanatic of the games...I can just say that I'm glad I got in to see it for free. Granted, it could have been much worse...but I personally was let down.
2. Resident Evil games are unfortunately not as psychologically scary as Silent Hill, but man, it has some jump moments. Especially in 1 & 2.
3. Fatal Frame rocks. Still haven't played the third one though.
4. The name of the game with Art Bell is "Prey". Never played much of it, but here's a youtube of the soundclip laced over some gameplay. Unfortunately the guy had to do it this way, but you still get to hear the HORRIBLE "caller's" voice acting skills.
http://www.youtube.com/v/jh9IF6JdW3s&hl5. Deus Ex is 100% certified bad ass.
