I agree in some ways with the OP. Under no conditions, EVER should an archer, knight, or whatever be able to beat a full str gunship, or any modern unit. These assumptions like out of fuel, caught sleeping etc are lame. There are some things that are unseen but get done, such as supply lines, food, fuel ammo etc getting to your troops. (BTW in dangerous times guys sleep inside the tank, and in shifts)
Now, you can't have the first player to infantry just go around totaly mopping the floor with player with riflemen. However, If you have Longbow men vs Gunships and Tanks, you deserve to lose, utterly.
My suggestion is this: as well as having gunpower, mounted, armored etc classification, units are classifed as Ancient, Ren, Industrial, Modern. So, a bowman would be Ancient, archery. Knight Ren, Mounted. Gunship Modern, Helicopter, etc.
To end this problem, Industrial age units could get a 50% bonus vs ancient, and modern could get a 100% bonus. This way, even if you Modern armor was down to 5/40 it would actually be 10 vs 8 of an elephant, etc.
Civ4 has done a far better job then Civ3 on balance. However, 2 last points. They really should do something, my suggestion or another, that modern armies should totaly plow ancient ones, no matter what thier bonuses.
Second point is, you shouldnt be playing on a difficulty where you have modern armor and the AI has longbow men and elephants in the first place, so such a fight should never happen
