Most of my picks have been said already. FFIX, Skies of Arcadia, Golden Sun, Ni no Kuni. All have amazing locales that are just a joy to explore and poke around in. I'm going to give a special shout out to Xenoblade as well for the sheer amazing variety of places, not to mention how gorgeous the towns all are and how seamless they are as well. Colony 6 in particular since you actually build the town back up from scratch, seeing it change and rebuild after what happens is awesome.