From a personal point of view, I think automatic updates are all well and good. If it keeps the teeming masses of non-tech people up to date on their software patches, I think that reduces the risks for us all, kind of like vaccinations.
What we do need, however, is better control over it.
For instance, I note that I can set "active hours" on windows update that it won't do updates from such to such time. This is good, in theory, but it isn't flexible enough, because it has a hard limit of a 12h span. As someone who works and plays on the same machine, I don't want updates happening while I'm awake. If they happen overnight, great. But from 0500 to 2200 I don't want updates applied. A 7h update window overnight when I've specified it can update should be more than long enough.
One thing that I think would help a lot is if people could set a date AND time for updates to be applied that is a bit less often than once a week. Say, every other week or even once a month. Like the old "patch Tuesday", except with everyone picking their own day. It would be even better if people could set the time on that day. Then they would know exactly when it is going to be updated, and likely restarted. Bonus points if other software, such as browsers, office suites, etc, could recognize this setting and they all do their updates together. The key here is control.
As a side note, I have heard that some versions of windows have a "Delayed update pattern" where only security updates get pushed out immediately, and all non-security updates are delayed by a month. So stuff adding new features and miscellaneous updates are delayed, presumably to give them a chance to be tested and bug-fix. I'm guessing this is probably an enterprise feature, but it should be on Pro too.
I'm all for everyone being forced to get security updates, but the users need a lot more control over when those updates happen, and ways to ensure that it absolutely does not happen when we need them to work.