Hotels/motels are dense enough that they don't take usable land away from residential housing while still allowing for short-term residents to enjoy the city.

However, AirBNBs and rental houses suck away the usable land such that you begin to meaningfully remove potential long-term residents from the city. The flipside of this, of course, would be apartments/duplexes, which would add more long-term residents than single-family zoning would allow, even with the problem of AirBNB proliferation.