The Stanley Parable is a HL2 mod that's recently caught my attention as creepy and eye opening.

The mod questions a gamer's state of awareness while playing a game, and provides many different endings based on the player's choices to follow instructions.

With all of the awful videogame creepypasta drifting around, this is an interesting change.