My original comment wasn't based on subletting, it was based on the transient nature of a hotel/motel/B&B guest as opposed to a neighbor (regardless of whether the neighbor owns/rents/sublets).
There is a wide range of what is acceptable to various people in this context. For some, not knowing who their neighbors are from day to day may not be a big deal. Maybe they like forming new associations constantly, or maybe they avoid forming any associations. Either way, they don't care if the people around them are the same as yesterday or will be the same tomorrow. Others like more constancy in their associations, especially those who are around them when they are most vulnerable (i.e. at home where a lot of relaxing, bathing, and sleeping takes place). It is a tribute to society that many of us feel safe in a variety of circumstances that leave us vulnerable to those around us. We don't feel like we have to live with armed guards, nor constantly watch our backs to make sure someone isn't putting a knife into it. But how comfortable you are in the presence of strangers when you are vulnerable depends a lot on your level of trust in others and/or your ignorance of what can go wrong.
I think people usually expect and operate with the default assumption that the people around them are mostly like themselves, and they govern their actions accordingly. Short-term transient rentals will almost certainly play havoc with those assumptions on both parts. The "inconsiderate assholes" who show up late at night for their AirBnB accommodation probably aren't assholes at all. Their travel was delayed, they are tired and worn out, and they just want to get to a touchdown/relaxation spot. But their assumptions about what constitutes "good behavior" under those circumstances are very different than those of the long-term residents around them think, because they have very different expectations and motivations.
I'm familiar with a circumstance in which the equivalent business to a short-term rental opened in a very small neighborhood (private road off of a county road, six houses). This business has 24 hour a day operations, 7 days per week, with at least 3 employees per shift. Obviously way above/beyond AirBnB of course. The culture clash is enormous. For example, the employees speed down the road when they are late for work (and its not uncommon for people to be running late in the morning). Because its a private road, its only 18 feet wide, not the minimum 22 feet of a county road. The residents know each other, and always slow down to pass each other. The employees don't slow down a bit; I suspect they don't realize the road is as narrow as it is. I'm sure the employees don't understand why the neighbors dislike them so much - they are just working for a living, like everyone else, right? But unlike the residents, there is no tie of the employees to the neighborhood. Its just their job, not where they live.