When people say they "bring money in", worth seeing where the money goes. Tourists spend in the most scammy cynical price gouging businesses and in multinationals. The profit margins of these businesses is not local wealth - the financial impact locals see is property price inflation. In most tourist cities, you don't need to walk far from the main attraction to see desperate poverty.

There is opportunity cost. When a political administration leans into the "tourist industry" they are not growing other industry and enterprise that creates high value jobs for locals. The jobs tourism creates are entry level service workers that will likely served by immigrants also attracted by the same dynamics as tourists and more easily exploited by a loathsome industry.

(Admittedly, Barcelona seems to have about 20 million overnight stays plus cruise ships, but it also has almost three times the population of Duesseldorf)