The most boring type of combat for me is turn based without real positioning. And that "real time action" is included in this. Games include, sadly, FFVII (which I own and do not feel like going back to play), most of the main line Final Fantasies, Bravely Default (I have played the demo of this, I can't see the full game combat system to be drastically different), Chrono Trigger, Pokemon etc. These games basically turn into mashing A and maybe a few D-pad presses until the battle is finished, which for obvious reasons is unappealing. I'm sure the stories are great, but I'm never going to make it there.
I'm kinda just taking one point and running with it here but I really liked Bravely Default's combat system. It was fairly easy to see how to best use it most of the time (spam Brave on random enemies, spend as much time as possible Defaulting on bosses) but that still puts a very unique spin on the combat compared to most other RPGs, even though the jobs and such are all standard FF issue. I'm disappointed at how the game was so needlessly and honestly kind of insultingly padded out though, I ended up getting bored of it in chapter 7. Bravely Second probably won't pull the same stunt though so I'm looking forward to it.