My doc got me some serious topical shit from a compounding pharmacy : 30% benzocaine, 6% lidocaine, 6% tetracaine. Gotta put it on at scale and rub it in really thoroughly (use an exam glove for this so your fingers don't go numb), and cover it with plastic wrap. Do that an hour to 90 minutes before the appointment, and have a gummy on the way in.

That made it survivable for me, still not fun tho.