The original Resident Evil was pretty revolutionary and terrifying for me, but the 100% scariest I’ve played is the original Dead Space.
More recently, The Outlast Trials is really good, and I would HIGHLY recommend any of the Dark Pictures Anthology games, but my favorite is Man of Medan.