What's problematic for being useless i.e tanged city attacks in early game is one of the worst offenders in the game literally 20~30 turns later when every single city gets the walls up and running.
It's one-shoting contemporary ranged and mounted ranged units .... even worse when arsenals starts appearing you can and you sill get attacked by city ranged strikes inside your own territory and this is way before 3 tiles range arrillery 3 becomes online.
Personally i think Archer and other units too rush is an exploit that i'm willing to overlook just because how trying to fix it would probably exaggerate the effects of an already annoying mechanic.
It has a short execution window before walls get online and archers basically become useless against cities.
The change that makes city damage actually scale on

CS means that we can meaningfully address city defence for the first time. Gazebo’s right, we’ve been dealing with half-measures this entire time, and it’s causing opinions to fly off in wild directions. The main cause of this is we have an entirely new mechanic on our hands, but it’s being boosted by buildings/policies/etc still balanced around the old, obtuse and opaque system.
first thing, I think we should reduce ALL defense buildings to 10

City defense. Walls currently have 15

and are factored into city damage now, and they can quadruple a city’s damage output. We can completely do away with city ranged strikes on castles and military bases until we have a better grasp of how the base

defense stat holds up in a game on its own.
If cities are falling too fast, we can add HP at the appropriate building.
If city DPS falls off we can give the appropriate building level a strike modifier back.
right now we are getting all sorts of reports about cities being murder machines past castles, and of course they are. They are currently getting 25

CS above whatever their base

defence would be from

population/hills/garrisons AND a +15% modifier. The highest defence stat these cities will face is a 25

samurai for at least an era. We’ve stacked so many bonuses onto defence buildings in order to patch up a broken city defence mechanic. Now that broken system is gone and only the band-aids are left; we need to wipe the slate clean and reorient ourselves.
EDIT: I imagine we could get to a point with the new system where the ranged strike modifier is reserved for UBs and wonders like Red Fort or Himeji.