The businesses that cater to this influx of tourist spending employ locals, which pushes up local wages and spending. The goods/services produced are also not scarce. They can be increased in supply. In fact higher volume retail shops result in more economies of scale, which can reduce local prices.
In a housing supply restricted market, tourism can contribute to higher housing costs, but that can be fixed by removing constraints on housing supply, like zoning. And even when this effect is present, its effect on quality of life is counter-acted by the positive effect of tourism spending on local incomes.
Local businesses do not always generate income from tourists. For example, some of the destinations complaining about overtourism are upset at cruise ships, where the tourists do all their eating, drinking, and sleeping on the boat, and they only walk through the city during the day without spending any significant amount of money.
Tourism is an industry that pays less than most. Most tourism/hospitality jobs are low-income and menial which compared to the exponential rise in both property value and everyday goods, is peanuts.
Hawaii, a state whose largest contributor to GDP is tourism has 1 in 6 residents living under the poverty line. The lack of other jobs and focus towards locals drives most people to poverty.
If the locality is fortunate enough to have home-sharing, the profits from tourism accommodations also flow to local pockets, creating potentially thousands of high income micro-hoteliers.
Moreover, not all tourism spending directly contributes to what are traditionally considered "tourism jobs". For example it contributes to more revenues for restaurants, retail businesses, etc.
As for Hawaii, I think a much better explanation for its poverty levels is the migration of people from other parts of the US to enjoy Hawaii's homeless-friendly climate.
Secondly - as I have already mentioned, tourists are price-insensitive, so businesses have no incentive to reduce prices by employing "economies of scale".