Loved Dead Space 1&2 and the Resident evil games (the remakes and 7, 8). In terms of story, Silent Hill II is probably my favorite and i’m eagerly awaiting the remake
EDIT: idk if Bloodborne counts as a horror game really, but that is probably the best Lovecraftian game i’ve played