I tend to detest turn-based combat in general, but my favorite of that type would probably be the Knights of the Old Republic series, because the whole game doesn't grind to a halt every time you run into someone and it actually feels like there's some tension.