One of the big drivers for me remaining in the Apple ecosystem is how well I like their management of my music and photos/vidéos.
Until Apple decided to change from iPhoto to Photos and you end up having duplicate libraries. Ask me how I know that one :)
which is why I will never use a smartphone that refuses the owner/operator access to basic things like file storage and the ability to treat the phone like a hard drive when plugged in, allowing anything to access, swap and replace files for you.
Would you believe that's not built into the OS in OSX for Android phones? There's an Android device manager app that can be used, but it's clunky and slow.
I miss the trackpad on my Macbook, but I'm happy with Windows 10. It's not like the XP or Vista days anymore :)
OP, I've mostly used a combination of
Systweak Photo Organizer and
Duplicate Photos Fixer Pro. In the previous thread Daley has recommended a couple of free alternatives.
Duplicate Photos Fixer Pro does a really good job at deleting duplicates (obviously photos only), but it's a subscription product and surprisingly expensive.
Systweak Photo Organizer does a good job at putting the photos into a structure, but doesn't do the same for video files. I've got them in a separate directory and will look at those later.
Try and find one that lets you set how much of a match you want it to be before a duplicate is flagged, and lets you tweak the auto-mark settings for deletion. I've used Duplicate Photos Fixer Pro to keep the oldest of any exact duplicates so I don't have a bunch of files of 2019-2020 modified dates. Systweak Photo Organizer sorts the photos by the date in the metadata.
There may be decent free applications or something cheap on the Microsoft Store that'll do what you're after better.