I had one prior to starting injectables when we were ttc my DS1. It was not bad at all in my case. I had a female RE, and she joked that she was more generous with anesthetic for the procedure than her male counterparts. Perhaps that helped. She was a great doc.
It was a long time ago (9 years) but it was not a big deal at all for me. I do have a pretty high pain tolerance but I don't remember it being painful.
I did not get vicodin. Just whatever local they used, and I think they suggested ibuprofen or tylenol afterward...can't recall as it has been a while. eta: no blockages, so maybe that helped too.
Mama to DS-2004
DD-2006
and a new addition-ds born march 2010