One of the things I've discovered about Auto capabilities of my digital camera 'progression' the past 10 years or so is that Auto keeps getting 'smarter'. I sometimes put my 5D Mark iii in Auto when I'm under some really screwy, mixed indoor lighting such as LED, florescent and sunlight all lighting the scene and I have been amazed at the good results.
The algorithms used by the camera manufacturers are likely 'top secret' within the company and I'm sure they continually adjust the Auto programming to handle a little bit different than xxx situation, or whatever. But the wizards in Japan don't 'see' the desired photograph as I 'see' it. Nor do 'they' recognize when I want to shoot 'wide open' for a thin DoF, or stopped down a bit to get a group shot, or a slow shutter speed to intentionally cause some blur, etc. The automated decision logic used is based on the most common types of photographs...people pictures, scenery, tourist-type shots, baby pictures, and perhaps even some concert-type situations with flashing lights or from the back of the room. The cameras probably recognize sunrise/sunset pictures as well. But put a subject or two looking at the camera with their backs to the sun...the subjects will be underexposed as the camera is exposing for the bright sun. In low light situations, the camera will likely use a larger aperture and/or slower shutter speed and/or higher ISO speed, to get the 'best' exposure with the least amount of moving-subject blur. But it has 'limits' of how far to automatically go on each setting without getting too much noise, or too much blur, or too under exposed, etc.
Perhaps the easiest way to start shooting beyond Auto mode is to use either Av (aperture priority) or Tv (time priority (shutter-speed) where you select one of the priorities and let the camera do the rest. I was at an outdoor car show a couple of months ago and shot everything in Av...f8...to get a good depth of field (DoF) of the individual cars. Zoomed in, zoomed out, sun behind me, to the side, or even in front of me, I always got most or all of each car in focus (DoF) and an accurate exposure. At other times, such as taking pictures of trains or moving cars, I've gone to Tv and set my shutter speed high enough to stop action, and let the camera do the rest. It comes down to -recognizing- when Auto won't give the results you want and then determining how to handle it fully- or semi-manually.
But it would appear that as you've been using Auto more or less exclusively, you really need to learn about the basics of photography...the exposure triangle, in particular. Here's a site with some great tutorials...
Cambridge in Colour - Photography Tutorials & Learning Community