The closest game I can think of would be FFX. I don't love it by any means, but I think the battle system is pretty solid, and the art design is fairly cool.The story, on the other hand...
"HA HA HA HA HA! HA HA HA HA HA! HA HA HA HA HA HA HA..."
...and I think that quote speaks for itself. It didn't help that Tidus was one of the most whiny POS's I've seen. And so, while I like the game, devoid of it's actual story, the story turns the whole experience into something that I'm not really proud to say I actually like at all.
Generally, if a RPG has mediocre-or-below gameplay, but a good story, I have no problem with liking it. When a game has good gameplay but a meh story, I still have no problem with liking it. But when a game still has good gameplay, but at least has elements of the story that I consider downright insulting, ("HA HA HA HA HA HA!!!) that's when I have a problem.