How long did Gondor's Walls last? (LOTR:ROTK) That was one short seige for one long movie!
This is not a good example though, history shows that well defended cities with walls have held out for long periods of time (even into months) forcing the attacker into a long drawn out sieges. Frontal assaults usually fail & those that were successful paid extremely high prices:
siege of Jerusalem 72ad, Siege of constaninople (all of them, 7 or 8), Alesia, Gibralter, Troy (recent research suggest a historical battle did in fact take place). Even early gunpowder was not so easily able to take down strongly defended fortresses (constantinople 1543, malta 1565).
Fortress tech should provided a massive defender advantage, but correspondingly needs to be very expensive in both tech & resource cost. Since this is a fantasy game, perhaps magic could supplement the siege capability somehow .. those teleporting elementals could appear beyond the city walls for example, or flying units could "fly" over them (not that I've seen any flying units).
There should actually be city walls that span the tactical grid & one should be able to position archers on these walls and they should get a "massive" defense bonus, like 200/300% at least. It should be "extremely" difficult for a human to take down an AI city defended by 5/6 archers and a couple of heroes (human should at least lose several units), and it should be "impossible" for an uber human stack to beat an AI uber stack in a fortress. Perhaps the best that could be hoped for is to "soften" up the defense a little at the cost of the attacking force minus heroes who could escape. Of course this is an end-game tech that goes hand-in-hand with catapults. BTW: it should go without saying that the attacker is not able to move from ground to wall square, except for flying or teleporting units.
There's basically a disconnect in this game with fortress tech, I'm just not seeing the fortresses in T.battles.