I've never used Auto on any of my DSLRs. :shake: The D70 had it, but I never used it, and the next three didn't have Auto. :shake: I've never used Program either. I want some input into what the camera is doing.

I use Aperture Priority 90% of the time, because I want . If the picture has a motion element, either freezing movement, or blurring movement, I'll use Shutter Priority. If I need for the camera to keep the same settings and not be affected by changing light levels then I'll use Manual.
I do/have occasionally use Auto on my compact camera, especially with the flash, because at least with my new camera, I haven't worked out how get as good pics changing the settings myself.
All Auto wants to do is give you at least 1/60th sec, (when the light gets low) it will change Aperture and ISO if it needs to achieve that. As far as I know there are not any cameras whose Auto takes into account the focal length used, so 1/60th sec is easy to handhold at 18mm, but may not be at 300mm. :shrug:
Some cameras, mainly compacts, have an Intelligent Auto mode, which 'know' what it is looking at, and sets the appropriate Scene Mode.

It is a bit freaky the first time you see it.
Irritatingly, when I use the Auto or Scene Modes on my compact it disables the RAW capture. :bang: