Nope. At least in Lisbon (which is probably just the same as Barcelona) the vast majority of them go straight at the tourist traps. They barely get any contact with the culture beyond having some foreigner guide pretend he knows about the city point at things while driving their rickshaw in the most annoying possible way. At the end of the day they end up eating whatever sounds foreign while listening to foreign music. This is an actual common complaint people have in Lisbon, that it is not Lisbon, it has been pretending it is Disneyland for the last 10-15 years.
There are places where people do that kind of tourism you're describing. Barcelona, Lisbon and a few more popular places, for the vast majority of tourists, is not.
As for the "support" argument, they mostly support low-wage low-qualification boss-owns-50-other-places businesses while, collaterally, raising the expenses of every other business, prompting those to just close the doors and move elsewhere. If you are qualified in basically anything, the job market in Lisbon is a mess. Plenty of people do lie about their qualifications to state them as lower than they are, just in order to get these crap jobs. The purchasing power fell, locals are actually much poorer since the mass tourism wave that started when the world rebound from 2008. The median salary in Lisbon is like 1000€ while a rent for a cube starts at like 800-1200€.
As for the "yell at the government", I don't know about the situation in Barcelona, but in Portugal, the far-right just received 20% of the votes because they are the only ones addressing those problems (in a very "close the doors" kind of way). Some municipalities straight up started not giving a damn at as they cash in more from the tourists than from the local's taxes. Oeiras and Cascais, two kind of famous tourist destinations next to Lisbon straight up are renaming official stuff to English in order to appease their real clients (eg. Not the people who live there).
Then you're not paying attention. Plenty of such protests-with-thousands in a few major places that were overwhelmed. Barcelona, Maiorca, Lisbon, Algarve, probably most of Greece, Italy, Southern France, etc...
It is not false that the government has blame, however, there's plenty of preverse incentive in here. Land prices skyrocketed and a lot of very well positioned individuals got very well in life.
At the end of the day, being a decent human being doesn't require laws. If you know you're competing with locals whose rents already are higher than their salaries, with their businesses that now can't support rents any longer and generally browsing fake-local-crap (and I assure you that most mass tourism is), then you're just making yourself unwelcome.
Even the "tourists are injecting money in the local economy" argument is in a good part bullshit. Ofc that some of it loops to everyone else, but the gains are generally very poorly distributed and many times negative as that money destroys homes and jobs.
If you go to some parts of Lisbon, you're not going to be able to hear one single word of Portuguese. Just yday I heard about a guy complaining that tourists attempted to forbid him from going into a waterfall near his home because... It ruins their photos and they waited in line to have them while the guy just "skipped the queue". Mass-tourists can't just figure that it is a country where people live and not a theme park, the "we paid to come here, we have rights" argument is heard plenty of times.