I've never been a big fan of artillery type of units, and so I've always under-utilized them. I understand a major exploit in civ3 was huge stacks of death of catapults, and so I think civ4 does a nice job of helping correct this (not fixed, but better) and forces players to use a little more strategy than just making a stack of 30+ cats
I am always wondering about such comments really. If you have played C3C, you can say that artillery is powerful. But it is slow, much slower than the favored attackers you have (like knights/cavs/tanks). So, if you prefer to fight using huge stacks of artillery on the offense, it comes with a heavy price. You need to build them all and wars will be slow, which will thus increase the chance of republic WW, where the key is fast and decisive wars.
The real great thing about artillery in C3C was the chance to fight off the huge stacks the AI sent. Meaning, you would use them to soften the attacker. If you have ever played AW in C3C, you know how fun artillery is, if combined properly with other units.
Let's see what CIV offers... Whoever claims here that SOD do not exist in CIV, is playing on far too low a difficulty. There is no other explanation for me as the AI can come up with very impressive stacks. Now, what do you do against those stacks? Guess what, you use suicde artillery to soften the stack. Often, you could suicide a few and use the rest of the artillery stack to eradicate the whole enemy stack, be it on the offense or defense. Anyone trying to attack enemy cities without stacks of artillery in CIV, obviously has not experienced the power of them.
Now, tell me, what is then so different that CIV is so far superior in this aspect? It's plain stupid for me to suicide artillery. I prefer the C3C model of a supplementary artillery. The issue that the AI did not know how to use them is an entirely different thing. Armies were huge fun and just because they couldn't bother to programme the AI to make use of them got them booted from CIV? Doesn't make sense.
If they would have bothered to keep the great concepts of C3C and combine with the great things CIV has to offer, we would have a truly enjoyable game. I do not particulary enjoy playing a game where I get constantly frustrated about nerfed options. I play to enjoy and enjoyment means for quite a few of us, that we win this game...with a proper challenge. It certainly is no fun for me to win a culture or space win by merely pressing enter many times. Or lose that way as well...boring...in CIV there is hardly any way to make a comeback if you have fallen behind...not my cup of tea