I could have written your exact post. AND my HSG was completely clear (it's no more painful than your first day of your period IMO, just sort of all at once instead of gradual cramping - my doc told me to take 4 ibu an hour beforehand). I got up and walked out and went to work no problem.
The fact of the matter is, with cases like mine, the scar tissue displaces the ovaries so they are not immediately adjacent to the tubes as they should be. We didn't find this out til we started going through fertility stuff and using clomid and doing timed insemination and IUI and stuff, as precursors to IVF. When they would ultrasound my ovaries to measure progress during the month and figure out when to do the deed, they always had trouble finding them or seeing them as they were not exactly where they should be. This, eventually, was the reason we all decided it was never gonig to work. We wasted 3 years and lots of temping and charting and timed, unsexy sex as well as a couple of thousand on doing useless IUI procedures when in fact the egg just could not get into the (perfectly normal) tubes. And some women struggle with tube problems/scarring as well, making it just impossible.
In the end, they basically said look, the only other option is IVF or quit trying. We took out a loan to pay for ONE cycle of IVF and hoped we would get enough eggs to be able to freeze some embryos and do future cycles with those. We only got enough eggs for one cycle, one try. 6 eggs, 4 successfully fertilized, only 3 made it to egg transfer day. One of them kicked the other two out - he is my 3 year old son.
IVF is very chancy. The success rates, particularly as you grow older, are low. I only had a 40% chance of success but we both agreed we could not grow further older into our 40s and not have at least tried it once. Had we not been successful, we would have felt like we did everything we could to have a child and it just wasn't going to be our future, and we had started to make alterate plans for a life including more travel, investment in an RV, etc so that we could make the most of our life as a childless couple and enjoy each other's company to the fullest. That we were lucky with the odds stacked against us is a miracle, but when I look at my son, I just think it's the best $15,000 I ever spent, and who cares if I never pay it off.