Thank you all for your responses. It is good to know that you can have a hysteroscopy without feeling too much pain, even if that isn’t always the case.. I have had one before but it was under general anaesthetic, so have no idea as to the level of pain to expect and with hindsight I really shouldn’t have spent too much time reading online horror stories. Feel so much better now I have read the comments here.
I've got another 'keen'... Ouch!