I like it when a game as no story but a very good gameplay, life counter strike for example.
I also like it when the story is very cool. The baldur's gate series is one of the few that managed to hook me up thanks to the story.
More recently there is Pillars of Eternity. The story and the world are very good, make me want to make a paper RPG in this universe.