Some of the better numbing creams last about an hour-ish. 4% Lidocaine is the max allowed over the counter, but you can get a higher % with a prescription.
As mentioned, once it wears off, the pain does feel "worse". I'd suggest that's because you went from feeling zero/minimal pain to how a...