A few years ago there was a campaign about pain relief and hysteroscopies, much good has it done! Different health authorities have different policies, some offering waking sedation, whilst others don't seem to offer anything unless it is explicitly asked for.
A few years when the hospital was urging me to have a hysteroscopy and didn't offer any pain relief, my GP prescribed Valium for me to take. This seems ridiculous to me as it would in effect be unsupervised. I only heard about a general when my daughter suggested I contact PALS and this resulted in me receiving a letter saying I could have one under general if needed.
If anyone has any issues please contact PALS as they are really helpful and sort things out for you, which greatly reduces the stress,