Tony,
I just retired and am spending time making sense of 30 years of digital photos piled into my system since getting my first Mac Plus in 1989. Like most people, I just wanted snapshots and memories. I moved into newspaper publishing and only used caption and title information, with a storage folder hierarchy that didn't require understanding metadata much beyond that. I now have photos scattered over five hard drives and a complete mess in Lightroom that I'm seeking to sort out, adding scanned slides from way back (without adding decent metatdata info) and just learning about how to establish creation date using info from the actual slides (like SEP75), which at least gets it down to a year, and I can guess a month most of the time.
Creation dates are particularly troublesome with operating systems and applications, applying different standards to IPTC,
I have just learned how to tap into all of the existing exif info in digital photos along with XMP info found on newer instances and am working out ways to batch process scans and older digital images with incorrect image creation dates (not drive creation dates). As I mentioned, Photo Mechanic seems like a pretty full featured program to do that, and will have a steep learning curve. I don't even know the right questions to ask yet. But I'm learning.
Thank you for reaching out. I will come back when I have a better idea of what to ask. Teach me to jump in before I get the facts right. I didn't realize it was so complicated.