Honestly, I think Final Fantasy IX had the most impressive cities with Lindblum and Alexandria. I loved Dali too. Something about that town reminded me of Arni Village in Chrono Cross (my personal favorite in any game).

I also love Besaid from Final Fantasy X.