BG and KotOR are not TB. You can pause, and there are turns being worked on behind the scenes, but you have no direct control over the turns. TB is also traditionally a non-frantic style of gameplay. You have as much time as you need to make your decisions, and the tactics are in the details. BG and KotOR were frantic, pause, frantic, pause...very different.
Civilization is an entirely different genre and so can't be compared to Fallout, Jagged Alliance, or ToEE. The TB functions on an entirely different level.
When you make combat real time, you are often giving up details like positioning, cover, and other tactics that can be interesting. But some people prefer the frenetic combat, so it's all about personal preferences.