With 5 cumulative years of infertility, most of that spent in online and RL support groups for IF, I have heard EVERY response on the spectrum.
A few report no pain or anything beyond a normal exam - on the other side a few have said it is absolutely excruciating, serious pain, way beyond "discomfort". And, oddly enough, there did not seem to be any correlation between pain level and whether there was a blockage or not. In fact, the woman i know who claims it was the WORST pain ever had no blockage whatsoever! Many are in the middle, experiencing mild-moderate cramping and pain. ALL have said to take the advil and/or other drugs if offerred, LOL! And I have known many who conceive in the month or 2 following.