A more interesting question, for me, than Civilization versus Final Fantasy might be this: Why do I enjoy Legend of Zelda: Skyward Sword but not Final Fantasy X?
They’re both linear storylines. In both, you walk from cut-scene to cut-scene, possibly with some combat in between.
It’s not as simple as real-time versus turn-based combat. I tend to prefer turn-based, and FFX is the one with turn-based combat.