I have never turned on auto-update, and I have had my work laptop restart on me without my permission. It simply showed me a dialogue box stating that the computer is going to restart upon hitting ok and that I better save my work. Where I work, we mob program, and this has happened to my team mates on many occasions.
(Apple has the ability to forcibly push updates, but they almost never use it.)