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.