I vote MedMod. Best AI, best gameplay.
For MP games that may be true, but I hardly know anyone in the CtP2 community who plays that game unmodded. For CtP1, it's hard to say since most people just/mostly play MP these days, but 2 years ago when the SP community was still very much alive, many people here would have laughed at a comment like that...
Mods to me are like Chess or Poker variants -- only a select small group play the variants but the majority of people play using the original rules.
I thought we were not playing single player against the a/i alone, but two separate civilizations each controlled by humans, hence my vote for no mods. I forgot that there are many SP players participating in this democratic game. But as the concensus is playing single player, I agree -- make the a/i as good as you can. Like many said, the a/i is not very good in single player mode -- unmodded.
Comment