There is a lot wrong with this entire concept. Communities may not be appropriate for “affordable housing”. If the economics don’t fit, trying to force it just results in absurd outcomes and effective waste of money that could be more useful in other areas.
Home business issues? Depends on the local impact. Air BnB? That’s another area worthy of separate and deep discussion.