I use them in the early game period. Then I move onto catapults and then cannon/guns when gunpowder phase begins. The game AI forces seems to favor ballistas throughout the entire game I have noticed.