So something that I've been thinking about, using Program-mode or full Auto-mode when lighting conditions are good and when one wishes to shoot with a middle-of-the-road aperture will probably result in images of similar quality to more manual control. After all, in those good conditions, the photographer might well end up manually setting up the camera the same way that the software in the camera would.
As an example, this was taken many years ago when I was not manually controlling the camera:
Canon EOS Rebel XS, 29mm f/9.9(?) 1/160th second ISO 1600, mild crop
We were in a tent but the lighting was good enough that the camera captured an image on automatic that did a decent job with the setting, the people, and the fire they were juggling. Presumably if I did some extra editing (jpeg, I wasn't shooting raw back then) I could make the photo even better with little work. The camera chose a speed that froze the people but didn't make the flame look bad.
This I took the same year on the same camera with the same lens, also automatic settings:
Canon EOS Rebel XS, 18mm f/4.0 1/60th second, ISO400, mild crop
The camera did its best in very poor light, used the onboard flash (as just about all of the pictures I took of people posing at our Transporter Console did) and it's functional but not a particularly great shot. If I had to do it over again I would have taken a lot more time to figure out camera settings that either didn't require the flash, or where manual control plus some kind of extra lighting (be it flash or other) would have helped. Several of the photos from that event turned out quite a bit worse, where either I had problems with having people on both sides of the prop in-focus at the same time, or where the brighter, bolder colors of the prop are washed-out based on what the people were wearing combined with the black curtaining in the background.
I'm sure as a free souvenir photo it was fine, but I know I could do better in challenging conditions now even with that older camera.