It's pretty rare that I'll play a game with characters that I don't like so much, but if I do, you can bet that I really love the narrative. The only real examples I can think of are these Final Fantasy games.

Final Fantasy X
Final Fantasy XI
Final Fantasy XIV