Haunting Ground.
Ooooooh, nice.

Yeah but most game creepypastas are just awful. Really I think Ben Drowned and a few of the Pokemon ones(specifically, Creepy Black and Lost Silver) are the only ones worth considering to be scary, and even those are a bit of a stretch. I won't even go into how shamefully bad the Metroid one is.
I'm gonna throw some obscure titles in. Rule of Rose, Call of Cthulhu:Dark Corners of the Earth, Hellknight/Dark Messiah.
And some classics like Clock Tower and Amnesia.
Aaaaand a few goof creepies like Romero's Head and the Gabe Newell room.