Dino Crisis (1999)
Silent Hill 3 (2003)
Amnesia: The Dark Descent (2010)
Haven't played many horror games, but the above were both gripping and terrifying to me. Well, Dino Crisis also was fun, so it didn't offer the same level of terror that the two others did, but I remember playing very carefully and in suspense, so I will count it.