...
and finally its pretty historically accurate. spear was a poor mans' weapon and mass spearmen were used for tribal militias or those who lacked iron (think of egypt or greece). they couldnt stop swordsmen if not outnumber them. ...
I definitely disagree.
What a spear (opr rather long spear, with regards to the Phalanx) is capable of totally depends on training and strategy.
The greek Phalanx dominated the known world in ancient times, so much that most states (including egypt and persia) would hire greek phalanx units as mercenaries.
Why?
Because the greek combined the long spear with superior tactics (i.e. letting them fight as coherent units with a wall of spears facing the enemy) with the necessary training (to keep the units together during maneuvres)
The importance of strategies with the long spear can also be seen in 2 things:
1. Pillip II and Alexander of Macedon dominated over the greek phalanx. Why? Because they combined their own Phalanxes with flanking attacks by horsemen (which would attack the Phalanx from ttheir vulnerable sides and back)
2. Under Alexander however, the Phalanx again dominated against the persian king Darius, despite the persian king having numerical total superiority and a huge mix of different unit types (and also the choice of the battlefield, ideal for his chariots). Again this was due to superior tactics and training, that Alexander dominated.
Also, at this time the phalanx was a rather offensive unit, not a defensive one.
All only changed when the romans appeared ... also not because of superior weapons, but because of superior strategies, by combining more tactically flexible units with good training (and thereby being able to exploit gaps in the greek phalanx formations to, again, get behind the spear walls and attack their sides)
You are right, however, that the spear may be a poor mans weapon during medieval times ... and that also is not because of the weapon, but because of the lack of training those spear units received. The ancient strategies at this time remained largely forgotten.
When the swiss Pikeniers appeared (and surprisingly claimed repeated victories against seemingly superior knights forces) this was just the rediscovery of the ancient greek phalanx system (and therefore again just a superiority in tactics and training) anjd atz this time (inj ncontrast to ancient times), yes, it was primarily used as an Anti-Horseman/knight-Weapon
Hypothetically, if one would actually want to implement this in Civ, strategies/tactics (and formation training) would have to be superior in contrast to the weapons used by the units (with seemingly inferior troops (due to their weapon) claiming superiority over a little bit more advanced troops due to their training/tactics