I have to give myself a shot every other week. Fortunately, I get to use the pen instead of the standard needle. It barely hurts unless my hand moves a little, but any pain generally comes from feeling the medicine go in as opposed to the needle itself. Icing the area helps.
However, I can't watch someone else give me a shot or take blood. I always close my eyes, because if I see them, it hurts.