Mate, something like Immich or digikam (if you want local) will do a good job at this. Not perfect but perfection is utopia. I fed 40k images to Immich and it did a reasonable job in not too many hrs.