I have played Resident evil...and didn't like them...wasn't scary, but my sister and her boyfriend played SH 2 and said it had both of them crapping their pants...
Resident Evil 2 - was scared to death when the dogs jumped out of the window 8) Otherwise the Elvira games were pretty cool but perhaps wrong to classify them as horror.