That happens to me whenever I play a highly rated game that I find I don't like or a disappointing game from a series I like. I think it was partciularly strong with the Tomb Raider games, FF12 and Dirge of Cerberus; I wanted to like them and get into them but I just couldn't. To a certain extent this has also happened with the Zelda games I've played (OoT being the main one), although I've managed to enjoy them a bit (just not as much as the fans do).
To a certain extent, this has also happened when I've played strategy games, because I feel that I should like them (since they are often seen as the thinking man's video game genre). Maybe I like games that give my brain a workout, but only a very light one :3
I think the worst thing about trying to like a game and then failing is that people often overreact. If they were expecting a game to be brilliant but find that it was just "OK" or "quite good, but not 10/10", or even "one of the best, but not the best", then they end up really hating it and can't seem to stop talking about how awful and overrated (god I hate that word) it is, when it wasn't really that bad at all. I like to think that I don't do that. :3