Catapults are not cheap! At 50 hammers they cost the same as horse archers and 10 more than swordsmen.
That being the case, CR is generally the best promotion when attacking cities.
It seems drill is useful when attacking a super strong defender that you are unlikely damage at all.
Barrage is useful when attacking a city with a big garrison consisting of several strong defenders, especially if they have lots of drill promos. But I would swap back to CR after a couple of barrage suicides, because... catapults are not cheap!
Catapults are 40 hammers in vanilla, dont know if they increased their cost in BTS.
Early game with swordsmen and Horse archers, catapults do plenty of damage to the defending unit, together with collateral damage, you cant get a better return for your 40 hammers. Later on in the game with macemen(70 hammers) and even grenadiers(120 hammers) catapults are worth their weight in gold with barrage promotions.
City Raider I( 20% city attack) Catapult with 5 strength goes to 6 strength, cats will still die most of the time and do minimal collateral damage.
City Raider II(25% city attack) cats with 6.25 strenth, cats will still die most of the time.
when a cat is attacking a garrisoned unit, that unit is usually fortified for 25% strength plus additional promotions that unit may have, which can take an archer from 3 strength to 6-8 strength or a longbow from 6 strength to 10-12 strength making your cats with CR II still only 6.25 strength, that cat will die and only cause 2-4 damage??
Cat with barrage II might only give 1 damage to a longbow but 1.8 collateral damage to 3 other units equals 6.4 damage, even with no damage given to defending unit still causes 5.4 damage, thats worse case scenario, most times a cat can do 3-6 damage to defending unit coupled with colateral damage, thats 8.4-11.4 damage inflicted per cat. What can stand up to that much power? A city garrisoned with 10 grenadiers will be decimated against 0nly 10 cats, leaving your other units in the stack to clean up with no losses.
For me the catapult is still overpowered with barrage promotions.
early game not cheap but once you need to kill longbows and tougher later units the catapult becomes extremely cheap compared to macemen or knights you would normally attack with.
3 cats will do a lot more damage than 1 knight