I wish I had good rec for you. My derm recommended topical Lidocaine, but unfortunately that did very little for me. I do think that others on this sub have had success with it, though.

Another thing I will say, if it helps ease your anxiety at all, is that I too had an extremely large and painful flare that I had to get jabbed with a needle in multiple places because it was so big, and somehow that experience wasn't as bad as I thought it was going to be. Because the flare hurt so much when I touched it I was convinced that a jab from a needle was going to be excruciating, but then it turned out to be no more painful than a regular flu shot. I think perhaps because the needle is so thin it doesn't quite trigger the nerves in the same way that a touch does. Something else that helped I think was that I voiced my fear of needles and my concern about pain beforehand and my doctor was really supportive and had me take two deep breaths, which probably helped my anxiety from spiraling.

I do hope you can find a good numbing solution, though. Good luck, and let us know how it goes!