I’ve lived in various places
I’ve lived in various places in the US and Germany where auto maintenance was verboten in residential areas, and it was mostly because people refused to dispose of dangerous chemicals in a proper manner, though I believed noise and neighborhood eyesores did play into the regulatory decisions.
One of the positive outcomes in these areas was the rise in the business of renting shop space and providing assistance to those in the shop areas. Because of the availability of professionals to help out the DIYers, many more people that wouldn’t have previously tried were going to these shops to work on their own vehicles.
So despite how bad this sounds on the surface, it could end up building new businesses, fostering new car clubs, and actually getting more people into the gear head mentality (I’ve been working on cars since I was a little kid because my grandpa had a gas station, back when we used to do full service auto repair).