I suppose you wouldn't mind living next to this place then - http://www.latimes.com/local/lanow/la-me-ln-airbnb-party-hou...
I like my neighbors (except one... that's a different story...) They are friendly. We help each other clean off our cars in the winter. We check on each other's mail, pets, plants, and houses while we are on vacation. We help each other carry heavy items into the house. We are known to each other. I personally wouldn't feel safe with neighbors who revolve every day who have no ties to the community that we built.
Not to mention I wouldn't want to pay double rent because of all the houses that are taken off the market.
Or lived basically anywhere which has uni students.
Many places (like NY for example) actually have laws that expressly protect tenants rights to sublet.
Landlord tenant laws mostly are there to protect the tenant from unfair slumlords.
I've never had a problem with uni students in the city I used to live in and a couple lived in my building.