FF battle systems up through FF7/8/99 were generally not fun. On a recent playthrough of FF6, I almost went into a coma.
One simple way to make turn-based battles fun is make the game more difficult. A big reason battles in FF games aren't fun is because they're too easy. If you can tape the A button down and win all the battles, it's not a good system.
Case in point, Etrian Odyssey. You have to pay attention to the battles or you'll die. New monsters and FOEs can charge into a battle if you take too long. Elemental weaknesses actually matter because some enemies are very hard to kill otherwise. Enemies applying conditions to you actually matters because they will kill you. Lack of save points means you actually care if you survive the battles because you might lose an hour of progress if you die. Lack of resources (MP, healing items) means you actually care about each battle, because being inefficient will screw you over.

Originally Posted by
Black Magic Shopkeeper
Hmm, the most recent turn-based rpgs on consoles like the PS3 and XBox 360 I remember playing were Lost Odyssey and Resonance of Fate.
Lost Odyssey's timed-hit system was good enough to keep me awake. Even that little added feature made the battles pretty fun. It doesn't take much.
Resonance of Fate's system was fun because it was so unique and complicated, and because the character animations were ridiculous and glorious.