This is the primary reason housing is in crisis in the US. Tech workers and foreigners finding cheap but gentrifiable places and driving up the price of housing to the point no one can afford it but them.

While OP is right in that these people are a net good for the economy at large there's a reason a LOT of countries do not allow foreigners to own property. The US is one of the few places where you can without much trouble. You can see the problem this causes with states adjacent to California, like Nevada, where the average house is now over 10x the average income thanks to the tech emigration.

Even that is a good thing for local developers and homeowners.

Still blatlantly ignoring the majority of people who are not wealthy enough to profit from tourism, but only get the downsides of it, which I'm not going to list here as they are many and proven.

Edit: No, more potential careers as an underpaid waiter or touristic guide is not an upside.