And is Apple Pay alone sufficient to solve the issue, or is it the combo of debit card AND Apple Pay?
Hotels? They are already a regulated entity in most parts of the world for good reason.
There are too many money-grubbing, anti-social, weirdo hosts who don't clean the linen. In a hotel, at least you have recourse and can switch rooms.
And yes, indeed talk with locals if no hotels: I stayed for cheap/free for months with locals who were just lonely.
My first home away from home was a long term hotel FYI. They are definitely common, they just tend to fly under the radar, especially since many allow pets and possibly smoking depending on the area.
It sucks as a guest, the only solution is to either accept that you are just a magstripe or to stay in a hotel.
Long stays are difficult but I recommend furnishedfinders.con as an alternative.
There is also https://fairbnb.coop/ and independent vacation rental websites.
Everyone hates AirBnB now. The only problem is there is no sensible replacement available for it. Anything that claims so is 2x more expensive. Otherwise, for short stays (2-5 days and unless you are a family) a hotel is cheaper now.
What you can do is, in the future, replace your credit card with some dumb Debit Card. And pay with Apple Pay.