HSG, the good, the bad? real opinions please

If I get my period this week (please don't),  I will have to schedule an HSG at Kaiser. I wish we didn't have to go this route. I would love to hear anything about your personal experience with the HSG. Thanks! Baby dust to everyone here as always!