I consider it to be a lubricant in the engine of law. You can't run law to the letter, because defining the law is an AI-complete problem. The law tends to have more corner cases the more detailed you make it, and by executing it unconditionally, with maximum efficiency, you're going to harm a lot of innocent people. On the other hand, too much grease, and the engine won't run at all.
That's why I often remark about the importance of trust on a societal level, and my dislike towards the current trend of replacing trust with trustless systems. Trust is what keeps society together, and what allows it to work without humans having godlike introspection and cognitive powers.
The organic nature of case-by-case resolution of issues pretty much requires a long-term tenant that has some for of long-term relationship to the property and neighbors. Social pressure and personal responsibility come into play.
It's the difference (roughly) between a teacher-student and a parent-child relationship. In the former case, the (usual) lack of personal ties requires explicit rules. In the latter case, a lot of rules and conflict-resolution is more organic and case-by-case.
Which sounds like a great reason to not have a rule prohibiting short-term occupants in residential zones.