Help me understand what's going on with the reset circuit in this simulation.

Btw Pito, neither of your schematics actually represent the Uno or Leonardo reset circuits. Whether your circuits are correct or not, I don't know, but what I'm trying to figure out here is if the Uno and Leonardo schematics are correct.