As much as I love the Resident Evil games they haven't really scared me that much. I would say RE1 was the scariest when those dogs would jump out at you.
Now, Silent Hill on the other hand is a different story. Turn out the lights and play either 2 or 3. These games gave me nightmares.