Help with Date Metadata in Photos. How to Automate the Process?

Hi everyone! I'm facing a challenge with managing date metadata in my photos, and I would really appreciate your help.

Context: I started by looking into whether Google Photos could automatically change the capture date in the metadata so I could download the photos and maintain the order in other galleries, like Samsung's. Unfortunately, I found that it can't do this automatically; it only allows me to manually adjust the "creation date" on their platform, not the IPTC or XMP metadata fields where the "capture date" is stored in the photo file.

Now, I’m looking for a way to automate this process. Ideally, I want software that can read the date from the file name and place it in the "capture date" metadata field of each image. Does anyone have experience or advice on how to achieve this? Maybe there’s a tool or script that makes it easy. I'm asking here because perhaps Adobe has already provided a tool for this in their suite, or even Premiere might be able to help.

One of the challenges is that there are different date formats in the file names. For example, some images have the date in the format xx-xx-xx, others just as xxxxxx, and some have screenshot text before the date.

Any suggestions would be greatly appreciated! Thanks in advance!