Sure. The Longest Journey as a point & click adventure game is at best mediocre really. The puzzles are either too easy, pixel hunts, or the worst sort of frustrating 'logic'.
And yet it's easily one of my favourite games of all time, probably even in my top 10 were I to try and list every game I've ever played, because the characters, the story, and the way in which everything interacts is just so very, very good it puts TLJ above most everything else!
I've also got a high bug-tolerance and a fair bit of patience, which helps with buggy games as well.
Not just story either, the opposite works as well. I'm more than happy to put up with a shit story and lame characters if the game is just ridiculously fun! All sorts of reasons to love a game.