I'm watching/listening to some older Johnathan Coulton songs on Youtube. You should really check him out if you havent heard any of his songs.
He's an awesome musician.
I've only ever had one shot. It was in my arm, and was absolutely painless. I think she used a very thin needle or something. It started to swell after a week or two though, that's when it started to hurt. >_<