Does all acupuncture hurt?

I stopped going a little while back because getting the needles inserted was worse than anything I already had. Most of the time, it felt like I was being stabbed, and in the electric acupuncture, attaching the wires felt like it was tugging the needles in and from my skin. Several times, when the head (and especially the forehead) were part of the treatment, I had to bite my tongue and claw into my arms to distract myself as it felt like it hit the bone. The one time I was face up, and a needle went into my wrist, I was in immense pain for the entire session. Apparently, the guy was trained in China and had a lot of experience and certifications, so my confidence is shaken here. Is it worth trying again for insomnia, depression, and "intestinal distress", or is my experience the typical?