I think the current sweet spot is Civ5 with the Vox Populi mod that fixes many AI and gameplay oddities of the vanilla version. I hope Civ6 will overtake at some point, but it seems to still have a long way to go before being good enough.