Just to review because this has been such an interesting discussion. There are users who don't like the idea of automatic upgrading anything, there are those who are perfectly fine with automatic upgrades for minor releases but not for major releases, and there are those who are afraid to upgrade without some sort of fallback such as a revision or restore point. The discussion above has mixed in plugins, themes, and core when in reality, this is all about WordPress core specifically, minor releases. Auto updates for themes and plugins are not on the radar at this time.

The plan is to deliver auto upgrades for minor releases but enable constants in the WP Config file to manipulate their behavior such as disabling auto updates or doing both minor and major releases. As someone mentioned, either before or shortly after 3.7 is released, there will be a plugin created by someone which enable the common lay person to change the behavior of automatic updates.

I'm still ok with doing automatic minor release updates for my own WordPress site and as far as restore points go, are we not supposed to be backing up anyways prior to messing around with core?