@nonamethanks created a script which scans images & automatically applies the duplicate tag if it finds a pixel-perfect duplicate.
I was made aware of this when I uploaded post #4335603 which I only uploaded as I thought "it's a larger file size, it must be a better version of post #4335173" - yet it was automatically marked as duplicate and not approved.
Once the script was explained to me on Discord, I noticed that there were several more images which are thus should not have been uploaded (cutesexyrobutts duplicate).
Yet 5 of 6 were re-approved by @NWF_Renim
This is very discouraging to see as a normal uploader - feels like moderation is a total crap shoot.