Personally, it is a success.

Spent a decade or so in Sydney. Lived in multiple places all within a 5 km circle but three different local councils.

It felt slightly ridiculous as a resident, but it is insane from a planning point of view.

During the planning/building for the Olympics the amount of time and money wasted because of multiple councils was impressive, even for the Olympics.

One city, one local gov makes so much more sense.