Detroit has different problems than other cities. Slumlords are renting individual rooms in trashed homes not up to code.
This restriction stops short term rentals in neighborhoods, leaving areas zoned as business (neighborhoods close to downtown and Woodward) free to host.
Airbnb for the rich only. Seems backwards.