Almost always does, doesn't it? You're expecting it to end badly because everything has gone so well up to this point. Kind of ruins other stories that do turn out well, because you become reluctant to keep reading when things get worse.
Or at least I do. I read them and think, "Oh, God, what's going to happen?"