Spearman vs tank can work for you as well - given enough of a crisis, you may see your one remaining non-promoted longbowman hold up an enemy stack long enough for you to reinforce the city
(or maybe I just pick too many fights I can't win
)
In my most recent noble game, I lost a LOT of experienced maces and knights in battles with win % above 80 (lost a level 5 knight against a damaged CAT!!! % 99.6!!!!
). I did, however, also managed to wipe out half a dozen or so pillaging Keshiks using a single axe, never fighting with odds better than 25%. And of course, every now and then we all experience the joy of watching our suicide cats win at <1% odds
Normally, I would want to fight with better than 75% odds. If I can't get that, I bring in my kamikaze Cats, more units and just hope that when the smoke clears I still have enough units left to move onto the next battle.
As noted in other spear v tank threads, civ is a strategy game, not a simulation. It's not spears vs tanks, its units of strength x vs units of strength y.
(or maybe I just pick too many fights I can't win

In my most recent noble game, I lost a LOT of experienced maces and knights in battles with win % above 80 (lost a level 5 knight against a damaged CAT!!! % 99.6!!!!

Normally, I would want to fight with better than 75% odds. If I can't get that, I bring in my kamikaze Cats, more units and just hope that when the smoke clears I still have enough units left to move onto the next battle.
As noted in other spear v tank threads, civ is a strategy game, not a simulation. It's not spears vs tanks, its units of strength x vs units of strength y.