TL/DR at bottom
I'm not big on video game combat in RPGs, but realize that 75% to 95% of the game play can be combat centric.
I was brought up on turn based combat from my old pen and paper RPG days. It did not always make "sense", but was an accepted mechanic to keep chaotic combat somewhat organized. I mean, 5 or more players all shouting what they're doing all at the same time while the Game Master tries to have the NPCs doing things is untenable.
Enter computers (and consoles). Now things are more readily taken care in a smooth fashion. Turn based combat becomes less viable and action combat comes to the forefront. It makes more "sense", after all
In my search for video games where I can take control of a character and enjoy a world through my PC, I have come across lots of different combat types. I still prefer turn based combat, as that relies more on my strategic mind then my reflexes and reactions to what's happening on screen. But the turn based combat games I have played always have a "glaring glitch" somewhere. These "glitches" are not the same at all, but different "glitches" from game to game.
Three big examples for me are Neverwinter Nights (hybrid combat single player games), the Shadowrun series, and Valkyria Chronicles.
Neverwinter Nights tried to fuse turn based combat with action combat. We rolled for initiative and took our turns, sometimes pausing the action. But we also had hot keys for special abilities to throw in when felt like it. However, the glitch that drives me nuts in this series is the "random PC movement" that happens during combat. Yes, it "looks cool" for a character to move about during combat, but when a character moves into the range of another monster and then it comes into the battle, I get annoyed. Or when a character moves outside a door and suddenly stops attacking, I am almost ready to rage quit.
Shadowrun I enjoy, but the way we move our characters pisses me off. It is all or nothing. We click on the space we want our character to move to and then the PC does the pathing, all in one shot. We are unable to direct our character's movement. Opponents get to shoot at my characters as they move, so letting the computer plot the course is not always the best course.. I wish I could plot out the path to where I wanted to go instead of leaving it all up to my computer.
Valkyria Chronicles takes this a step further, because we get to shoot at the opponent, though this is controlled by the computer, not the player, which is where this game's "glitch" comes in. So many times, the members of my team in this game try to shoot the opponents when they are running behind tanks and other obstacles, wasting their precious shots in impossible situations. They just can not wait for the opponent to come from behind the obstacle, then shoot. Ugh! I want to slap those team members upside the head!
TL/DR: Seeking RPGs with "good" turn based combat
I realize most players today prefer action combat, but for those who prefer turn based combat, have you found an RPG that hits your "sweet spot?"