
Just had my first IV that I can remember (had one when I was 3) for IV sedation and was so relieved. Lightly pinching your hand with your thumb and forefinger hurts about the same. The needle may hurt less than a human pinch, actually.
The needle is tiny. And they take it right out. They replace it with this little tiny soft plastic tube so you won't be sitting there the whole time with metal in your arm.
The real challenge is in our heads. I was scared too. I watched multiple YouTube videos to prepare myself so nothing would come as a shock....and cried though every video. I asked them if they could put numbing cream on my arm, and although I didn't get it, they might give it to you. That's supposed to numb your arm a bit, which is more for psychological comfort. Physically, I didn't need it. When the moment came I was thinking, "Game face! This is not a big deal!" And it wasn't.
To distract yourself, you can listen to a podcast in earphones or talk to the people around you. When I've had blood drawn, I've literally asked extra staff to just talk to me for a few seconds. I have them tell me about their pets, their kids, just about anything.
Not to mention, IV Sedation is awesome. It is your friend. My surgery was 15 hours ago. I'm 33. I'm so old, one tooth was growing into my jaw and they had to remove bone matter. But I felt no pain (or fear!) under sedation, and nothing bad since I've been home, either.
P.S. Don't drink anything 8 hours before your appointment, but drink plenty before those eight hours! You know you did it right when your pee runs nice and clear! The water will give you nice big veins so the itty bitty needle only needs to enter a little bit of skin. They'll also ask you to clench your fist when they do it, which makes the arm feel stronger!