Most places have enough hotel capacity except for very special occasions meaning it mostly shifts value.
To an extent it has an effect it mostly decreases average cost of staying while increasing cost of actually living there almost like vacuuming money out the pockets of residents to give to Airbnb and tourists.
I am not even sure it decreases the cost of staying. Hotels are remarkable value except during peak season, and even then airbnb are also expensive. No financial benefit to the tourist.
