Auckland is nice because it can turn horrible cities into decent cities, or good cities into great cities. That being said, it's still situational, in that if you don't have a lot of coast, it's not very useful. And to maximize it, yes, you need to run Liang+Fisheries, which can take some effort. But other than maybe Nazca, no city-state does more for "bad" tiles.
I do like the city-states whose bonuses are good, but still more or less passive. Babylon, Bologna, Anatanrivo, Buenos Aires, Zanzibar, Geneva, Nan Madol, etc.. are all great because you essentially don't change your play, you just accept the bonus. They can still be annoying when you lose suzerain, but not to the level when you lose Auckland or Kumasi, where now I either need to suffer through horrible cities, or start re-routing my traders if I don't think I can get it back soon enough.
I do like the city-states whose bonuses are good, but still more or less passive. Babylon, Bologna, Anatanrivo, Buenos Aires, Zanzibar, Geneva, Nan Madol, etc.. are all great because you essentially don't change your play, you just accept the bonus. They can still be annoying when you lose suzerain, but not to the level when you lose Auckland or Kumasi, where now I either need to suffer through horrible cities, or start re-routing my traders if I don't think I can get it back soon enough.