I agree with the fact that the President should probably not visit foreign cities unless absolutely necessary.
In our case, President Obama (and I am a full supporter of his) visited our little town here in Australia (pop: ~100,000) back in 2011 to meet with our Prime Minister to ratify a deal to station about 10,000 US Marines in our town.
He was on the ground here for about 6 hours. For the whole day (and most of the day preceding), major roads were blocked and citizens could not get in or out of the city. RAAF fighter jets criss crossed our skies constantly during his stay, and the police kept all the local citizens out of parks and recreational areas near the airport.
It was a major PITA, to say the least, as commerce and general activity ground to a halt for everyone in our city.
During the same visit, President Obama also met with the Governor General of Australia in Canberra. Watching the televised meeting, I was amused to see that at the end of it, the president was whisked away by his security team in his motorcade, with police escort, whereas the Governor General simply walked back to his home along the river by himself.
The irony that the leader of the free world is probably the least free person in it...