That may be because for some later revisions of the modern Attinies a 12V pulse is not enough to reset the UPDI pin back to its UPDI function. Those chips need a powercycle short before the 12V pulse. All this to mitigate the risk that a static spike could reset the UPDI pin, which in theory could happen before that revision.
So your CH340 based (Adafruit) HV programmer may work fine for some older revisions. However for your 3224 you propapbly will have to build a PC-HV (powercycle highvoltage) programmer
At least thats what I had to do when I found out myself.
Here are my HV programmers. The top one is the CH340G based HV programmer (like you have). It works fine with older ones, like 204, 404, etc, unless Microchip decides to produce a new silicon revision of them.
The bottom one is the PC-HV programmer, that can deal with them all.
