There's a great deal of difference, and it hinges on time.
If your plan for visiting is "get the cheapest one-day return flight from Wherever, binge drink all night with your buddies, retch it up en route to airport and sleep on the return flight," all you care about is the cheap booze - literally nothing else matters (yes, this is a significant set of tourists around here).
Then you get the other tourists who actually come for something else spend money in addition to using the infrastructure. That is normal, albeit with major scaling problems (there's the issue - "don't have enough space to put all the tourists coming to see the Major Must-See Sights, as those aren't inflatable"). Those care about the appearance NOW ("people retching on public transport? How revolting!").
And then you get the normal city traffic - with locals, expats, and whoever else actually lives here. And those care about quality of life in long term ("what good is public transport, if it efficiently gets you into a city center that's devoid of actual life, only with a disneylandesque imitation? Will I want to live in such city in 5 years? What do I want to change?").
In other words, the longer you're planning to visit, the more probable it is that you'll be nicer about it, because you'll be expecting similar behavior in return. If you just pass through: eh well, break that window, piss in the street, kick that dog - not likely anyone will catch you within the remaining four hours. Note that this doesn't have any relation to whence the tourists are coming - the behavior correlates very closely with the length of the stay, be it an just-out-of-town sports team (common) or a stag party from the UK (also common).