Goldenrod is okay, but I'm not a fan of the cities. I mainly like Goldenrod for the GTS, the Game Corner, and the Magnet Train.
I'd so live in Ecruteak or Cianwood. Reason for Ecruteak is that I love the pagoda style houses and Japanese themed music, and I really like Bell Tower. But I'd live in Cianwood because it's close to the Whirl Islands and the Safari Zone. Not to mention the sea path to Hidden Tower. Plus, the medicine readily available in a small little house was really nice.