IOS – How to automatically copy new photos from an iPhone to a Windows PC when plugged in

I prefer backing up and syncing my photos locally vs using iCloud and as such I have been trying to automate the process of locally syncing newly taken photos on an iPhone to my PC but have not been able to find any obvious solutions. One of the additional challenges is i'm looking for a solution that would work for sometimes alternating imports of two (or more) different iPhones.

Preferred Solution Should:

• Automatically copy any new photos (and video) from the Camera Roll to a pre-configured folder after the phone is plugged in
• Keep the original filenames as they are on the phone
• Keep photos from different phones separate (ideally just sync them to a different folder)
• I'm looking to sync from iPhone -> PC only as i can already sync edited photos and albums from PC -> iPhone via iTunes
• Use native/free/scripted functionality

I can live with:

• Having a couple of mouse clicks to start or approve the transfer
• Doing the transfer over WiFi instead
• Don't mind if the folder structure from the phone is replicated or the photos are copied flat

Currently i manually do a copy via Windows Explorer and just tell windows to not copy any existing files but this is not very efficient and i have to remember to do it every time i plug the phone in.

Closest solution i have found that doesn't quite work for multiple devices is to use the Import functionality in Windows Photo App. This is also the listed method for importing pictures on the Apple Support Page

A non free solution i think may work is to use something like MTPDrive which exposes the phone as a drive and then script a SyncToy/copy script when the drive is available.