I mean, there are a lot of turn-based RPGs that are very fun to play.
To put in simply, how to make turn-based RPG to not make yawn every turn based battle?
Obviously, to make turn based combat more engaging.
Good examples are:
Shin Megami Tensei series (Incl. Persona), turn based battle system here is good. You cannot win just by pressing attack command every turn. You have to exploit enemy weaknesses and try to find a tactic to defeat each enemy.
And enemies here can defeat your party in few turns unless you defeat them first.
Final Fantasy 1 and 2 on NES. Yes these ones. Because there's no auto-targeting there. You have to plan your attacks to not make your characters attack a dead opponent ^_^
Etrian Odyssey, same as with Shin Megami Tensei ^_^