Agreed.
As a tourist you also tend to visit the historic center of capital cities, which have by far the best public transport and fanciest architecture.
Plus you're on vacation and having fun.
When you live there and walk to your commuter train a gray november morning, it's a very different experience.