There are certain cases where Auto Update doesn't work - such as when Microsoft update the Windows Update system itself. That happened around the time WGA appeared, and I've found PCs that had auto update turned on that hadn't updated in ages.
I like to know what software is being installed on my systems, so auto update is off.