15 years of Iphone pics...big organizational problem

So I've had a few iphones over the years, sometimes done backups using itunes back in the day, but always manually just pulled photos off the phones and into backup drives. Now I use icloud but it's only got stuff going back maybe 6 years.

I ran a free software on one of my backup drives to find duplicates and there are many duplicates of the same photos. This should be easy enough to delete the duplicates, but there are other issues...

Iphones name photos like IMG_1234. So, if you have over 10,000 photos, you have duplicates of the same number. Or, if you got a new phone and the people at the apple store couldn't clone your old data onto your new phone and you had to start fresh, you also have duplicates. I don't even take a lot of photos, I'm not that type of person, I actually have to force myself to take more photos generally, but in some cases I have 3 different photos with the same name. The software that finds duplicates knows that they are different, which is good.

So I want to eliminate the duplicates, and get them into folders by year to manage the duplicate file names... but there is one more issue... when you grab iphone files manually, they aren't rotated properly. They might even be left-right mirror reversed in some cases.

The software I am using also won't like, take a single version of each duplicated file and put it in a new folder...I'd have to delete the duplicates and then go find every folder on the drive and manually combine them.

There has to be a better way. Honestly I could probably write a php script to do this, but it might backfire.

Surely someone on this sub has tackled this? TIA