On many Sony models, you can set the camera to aperture priority instead of auto, set ISO to Auto ISO, and then change the max ISO to whatever you want; this is what I do in your situation.
Do you know if there is any option of setting a limit on shutter speed while in aperture mode?
(I understand I can go full manual, but that just doesn't allow for the same point-and-shoot experience in changing light conditions.)