3ds max had a great auto exposure feature for this that I loved. I haven’t found a way besides manually adjusting it in blender.
Last time I was looking into it I found this addon “Real Camera 3” that can adjust exposure automatically and should work, but I have not tried it personally.
Photographer - Camera Exposure, White balance and Autofocus might be worth looking into also, they don’t specifically say it has auto-exposure, but its got more real camera options and could make the manual process easier/more realistic.