I hate articles like these. Every city and township has their own set of ordinances that makes generalizations like this not possible. They might define RV differently, or they might only allow it for a limited amount of time, or only during the building of the dwelling. I've looked a lot in Michigan, and it's definitely possible in some places.
You have to go to the source yourself, per city, and figure it out. And the ordinances change over the years too. Something I wish someone would solve with an LLM and the mountain of data companies like LexisNexis have on local ordinances.