The last game that really drew me in (OCD, had-to-finish, where-does-the-plot-go level I mean) was Portal 2. I really enjoyed the game but I also really wanted to see where the story was going. Bioshock Infinite was like that as well, right up till the very end when it turned into an eye-rolling cliche of an ending (IMHO it thought it was being a lot cleverer then it actually was). Tomb Raider (2012 edition, they basically re-released the same game twice over since then!) was one I also wanted to really play just to see what was going to happen.
I've played a lot of games that I've enjoyed, but they were the among the few that really drew me in from a plot point.