All good intriguing info - but I still don't really 'get' what all the fuss about artillery is. OK, used in a combined arms force they can help to reduce a numerically and/or technically superior enemy to manageable levels. I will have to play a few more full games to really see any benefit from using this tactic.
But the main inspiration behind my original post was the seeming lack in Civ3 of a clearly superior defensive unit. 2 units of Phalanx and musketeers behind city walls in Civ2 could be pretty much relied upon to cope with all but the heaviest onslaughts. In Civ3 I don't see an equivalent, but this actually improves the game for me, as the 'guaranteed defence' aspect of Civ2 made for a much less nervy time of it as your enemy drew closer. I actually watch the battles in Civ3 with a kind of fascinated attention, emitting groans of despair and pathetic little yelps of joy where appropriate....
Having said that, IF there is a good defensive unit in Civ3, that can be utilised as effectively as the ones in Civ2 behind their city walls, I would love to hear about it. I won my first full game on Warlord very easily, but have become stuck on Regent. I always have a bad start and fail to recover in time.