During the day, I set the exposure once and change it when conditions change. That mostly works out but can be annoying when clouds and sunshine change often.
During golden hour or blue hour I want absolute control to get the lighting just right.
For astrophotography the camera's guess will completely wrong, so you have to shoot manual.
During night-time street photography, I dial the ISO up and set it to shutter priority mode. I want the time to be ideally over 1/200, otherwise movements of people start to streak. That often looks ugly. It can look nice but then it's an artistic choice and I set the exposure time accordingly.
So, long story short, I almost never use aperture mode.