-Half Life 2, as good as the scripted events and story were, the gameplay sucked and were stringed along by one gimmicky section after another.
-Portal, when you have a puzzle solved, there really isn't much fun in doing them again just to hear Glados' voice...=/
-Heavy Rain, I can only bare putting up with a string of QTEs just for the story.
Now for games I find myself going back to over and over:
-Fear 1, I still haven't found a game where the shoot outs are as fun as this.
-Gears 1, as dumb as the story is I'm just addicted to headshotting locust.
-Fallout 3, the immersion factor and the fact I'm pretty sure I haven't seen everything keeps dragging me back to this game.
Lesson learned here: an engrossing gameplay is what makes the difference, and games like the first three on my list just didn't hold up for a second play though as good as their stories were.