Mainline SMT games tend to fall into this category for me. I love the stories and while the cast is hardly bad, they're definitely not the main attraction for these games. Romancing SaGa 2 is another example of a great story, but don't hold your breath on character as so much of it has to come from the player.