meh no video game scared e as a kid, it was a atari 2600 and a nes in my youth, not very scary stuff on those. n64 was teen years. the only thing i can remember being scared of was not a game but, the flying monkeys in the wizard of oz when i was like 3-4 years old, for some reason it freaked me out then.
Edit: also, i just remembered, it was eternal darkness, the part where you walk into the bathroom and the body is in the tub for a brief second. that made me jump... but thats it, RE alwys seemed hokey to me.