Short answer, no! On a scale of 1 to 10 in terms of "discomfort" (ok, ok, in terms of "pain"), brow microblading is a 1 or a 2 when done with an experienced specialist. I stress the experienced part, because topical numbing creams only last for a certain period of time, e.g. 90 - 120 minutes, and if your Specialist takes longer than that to microblade your brows, the numbing starts to wear off and then... well, you start to feel things.
Also, topical numbing doesn't penetrate very deep into the skin, so a Specialist with a light hand will keep the strokes right at the surface.
The biggest distraction, at least for me? The sound of the tool doing its work, which is a odd scratching sound. That is, until I fall asleep, or put my earbuds on.
Post-treatment there might be a little soreness for a few hours as the brow swelling decreases. But keep the brow moisturized (at EverTrue we provide a soothing Healing Cream) and it won't bother you at all.
So, really nothing to be scared about!