One counterexample, right turn on red is not allowed anywhere in any borough of NYC. And outer Queens/Brooklyn/Staten Island are indistinguishable (to me) from the rest of Long Island (suburb). (i.e. not just downtown/busy areas of NYC)
Right turn on red really doesn't belong anywhere where people could be on the street. Drivers turning red will often pull forward into the crosswalk and there may be a walk signal.
In a right turn on green scenario, the driver mainly needs to be looking for pedestrians crossing and they will be crossing a different direction. In a right turn on red, their primary focus is on cars, limiting their attention on pedestrians. It also encourages creeping out into the crosswalk, blocking people from crossing on a signal.
That makes sense. Being European I’m often annoyed at not being allowed to turn right on red. Allowing it at non-pedestrian intersections would perhaps be a fair compromise.
Yes, NYC is not just pragmatically anti-car (which to some extent it needs to be), it is also ideologically anti-car, and that manifests in stupid rules like that.