The idea of a game, and I mean ANY game, not just modern ones, being turn based is a timeless concept. Games such as chess, checkers, various card games, these are all turn based. Why? Because the concept of turns gives rise to taking time for strategic thinking, thereby making the game more focused on tactics and of course the skill of the player. Even sports have their roots in being turn based, tennis for example gives service in turns, cricket/baseball have sides taking turns in batting/pitching etc.,
It's an interesting comparison actually. When you think of sports, we have almost fully real time games such as soccer, rugby, basketball etc., while also have turn based games such as baseball and cricket. Which do you like more? I've just thought about this now, but I definitely enjoy turn based sports more than real time (except Soccer, which while I don't follow religiously or anything, I find it much better to watch than rugby).
Real time games by their very nature are focused on immediacy and motor skills. The same can be seen in good action based video games. In my opinion, the Japanese have this genre hands down and almost solely this rests on the shoulders of Capcom. With their history in making brilliant real time fighting games, they've been able to expand into other action genres and produced some amazing real time action systems. Devil May Cry & Onimusha are good examples, and I think Dragon's Dogma also looks pretty cool.
When it comes to role playing games, all computer role playing games were born out of D&D, which of course is turn based for obvious reasons. I think the Codex rightly prefers turn based role playing games because frankly, party based mechanics, which are geared towards forming strategies using each member to win, begin to fall apart when everything is real time. The infinity engine games managed this with the use of a pause button, this was basically some kind of emulated turn based system. It worked okay, it was fun in many ways but it did change the game play significantly. You couldn't waste time in the middle of a fight casting the right buff at the right time because well, you didn't have any time. You had to prebuff, constantly, and this of course gave rise to crap things like rest spamming etc., In essence, it broke D&D, and while still being fun in some ways, it was broken.
SO tl;dr I think turn based systems are best for party based RPGs. It's very sad that current western developers can't see the value in this. Japan is still creating some great turn based games, and they sell a crapload as well. Devil Survivor was a really good game, had solid C&C, multiple endings etc., imo the DS had some of the best games on it in the past 5 years. The final fantasy tactics advanced games were childish and cartoony, but the combat was still fun.
Every AAA western developer seems hell bent on saying that turn based is like some kind of archaic outdated system. Then why do Japanese developers still make a lot of money from turn based games? Why do people still play cards, chess, scrabble etc.,? Words with friends is probably the biggest iPhone/Facebook game at the moment, and of course it is entirely turn based.
When I heard the DA2 developers trashing combat in DA1 and saying that "it was like chess" as something bad, I was really confused. Game developers should only DREAM of making a game as good as chess which has survived centuries, unchanged, and remains one of the most popular games in the world today. My guess is that anyone who says something like this is too fucking dumb to actually realize this, and of course could never make a game of any merit, whatsoever.