Call of Cthulhu is the best horror TTRPG.
You CANNOT win this game. It will either kill your character or throw them in a facility for the rest of their lives before you know it - well, there was one guy who won, but he basically railroaded the plot so hard that it was completely destroyed by...