I had an HSG done in 2018. It was no more uncomfortable than a smear. I do yoga regularly and basically just lay there doing lovely calming yoga breathing. Very slight cramping afterwards, I had taken the day off work and just went for cake afterwards (as a reward!).
My tubes were clear, no damage or blockage.
We DTD twice in the following week and I got pregnant with our DS who is now 2 ❤️
We are incredibly lucky that we have DS. We are TTC #2 and I’m on the list for an HSG again after a year of TTC (I’m 37).
So I recommend not reading horror stories, learning some yoga breathing, and keeping positive that the HSG is one step further towards your goal (more information, if there’s an issue you can hopefully get it treated, etc).
P.S. I went private as couldn’t get an appointment at my local hospital after 4 months (they used to only offer it on Mondays, so cd7-11 had to be a Monday, it never was, whereas at the private clinic they could offer alternative days). It cost £450 at Nuffield.