Do not boil the ocean. Map SKU, colorway, and channel first. Ignore cute folder names from 2019 until those three fields are trustworthy.
Assist tagging proposes attributes from filenames and EXIF. Treat proposals as drafts. Your taxonomy owners approve in bulk.
Near-duplicate detection catches the three packshots that differ by a white balance tweak. Keep the approved one; archive the rest with a pointer.