lazy to read all.. and i'm not in this field either
with all those acts etc..
just wanna put a simple point of view that might be related to topic(might be only)

there's diff between commercial and residential zoning.
i bet there's a reason for such other than taxing purposes.

like the case above if my neighborhood become like pub place and feeling less secure i wont like it.
while yes even a permanent residents might have frequent visits but it's kinda diff from a daily out of nowhere people come and go.

in both matters fishy things could be done to.. not to say a permanent resident wont drug deal etc..

it's just point of view i think.
people will tend to see the daily renting one as not comfortable

that's why i think it's best (not must)commercial purpose place in the commercial zone and home for home

i think it's about consideration. especially a condo type.