Here is a really interesting map of Stockholm comparing where locals (blue), versus tourists (red) take photos throughout the city. Yellow could be either tourist or local.
The results are pretty much what you would expect: high tourist concentration of photos around the main sightseeing locations in Stockholm, and locals in both the city centre, probably at bars and so on, and out in the suburbs.
I also liked Vienna:
You can see Schönbrunn out on the lower left hand side, with a huge concentration of photographic activity.
There are plenty more cities to check out – such as London, Moscow, LA and so on.