I had a very similiar experience with my HSG. It was done at an outpatient surgery center with a radiologist.

It was completely awful - in the end, they used a catheter they would use on a baby.

My advice - go to an RE who does these things every day. It made me super-paranoid when we did our IUI ...