I like having a home, or a HUB. Neketaka, or Athkatla are a brilliant thing to have. Think you return to, shop, hand in, and get new quests. A busy, living metropoly.
Cities in PoE1 were pretty bad overall - to make a big city work one needs to have a lot of things going on there, and a reason to return there. Perhaps we simply prefer our games differently. I thought a lot of PoE1 locations were problematic. Guilded Vale, for example, had little to no content. It was for the most part an empty map, which we would leave behind with no reason to return to. On a side note, Roderick's Caste is not a city - it's a dungeon. Dyrford Village was probably my favourite in PoE1 - with a nice vilalge feel (everyone knows about everything), and at least couple loops through the village (initial visit, trip and likely return from ruins, and loop, when searching for the missing daughter of the noble).
I loved coming in and out of Neketaka, and finding something new to do with every visit. I never tried to "clear it" though. Get enough quests to warrant a trip out, do that stuff, return, explore more, do some stuff in the city and venture out again. I saw many people complaining that they are stuck in Neketaka, but I think it is misunderstanding how this game is to be played.
I don't think Cities have to be big though. My favourite HUB in PoEs is still Stalwart, which is small and detailed. I love the feel of it, and how interconnected everything is. Being able to see it develop in WM2 was pretty great as well - that's something many games aspire to, but usually don't reach. A small scale of Stalwart was probably a good thing in that respect.
EDIT: A good city is what Outer Worlds is missing for me. The Groundbreaker is nice, but again, it's a nice single trip and afterwards it's a static, dead place. Fine for a dungeon, but not for a place where people live. Byzantium was just empty.