We do pretty much this exact same workflow at my job. We've settled on creating a "photo key" by joining the Feature Class and the "_ATTACH" table and copy/paste the attribute table into Excel, which we can use to associate notes etc with the various photos.
I tried modifying the script used to export photos to get a more descriptive name directly from the export, but didn't have any luck. However, I'm still a Python newbie so someone else might be more help, if that workflow is possible.
Would love to hear if anyone else has other recommended workflows for this!
Best,
Katie
“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek