Pretty much every single-player puzzler/platformer/adventure-styled game out there.
I'm talking everything from the likes of Braid, Limbo, Professor Laytons, Portal, and the like.
Don't get me wrong, these kinds of games are generally amazing fun and rewarding to play the first time through, but once you've solved the puzzle and gotten the plot, going back and playing them again is generally just Doing the Motions with none of the reward. The only way they could really be at all replayable is to come back to them after you've forgotten all of the solutions...