Almost all apartment leases have stipulations about excessive guests and required behavior. I don't see in your comment justification on why this required YET ANOTHER LAW and not just common sense and enforced contracts.

This law only bans absentee rentals. If the owner is not present what keeps the renter in sync with the other families living in the building?

The neighbors. The existing laws. The lease.

Totally agree with you - different countries / places have different norms on what is considered socially acceptable. So visitors can often have different expectations on what is considered late hours, what is being loud and how okay it is to dispose off trash in public places. Even ruling out bad behavior on part of the guests, they could be making a scene without knowing about it.