Hi Piggywiggy - please don't worry about the procedures. I've had a hysteroscopy 3 times and whilst it's not a champagne picnic, neither is it a horror story. The hospital will send you a fact sheet beforehand explaining that you can take pain relief, what to take and when to take it. I opted for the lot, co-codamol plus ibuprofen. It's a quick procedure, around 10/15 mins at most. Some hospitals will offer the option of a general anaesthetic, but honestly, unless you're terrified, that's a lot of downtime for a very simple, short procedure. You can also alert the hospital in advance of your anxieties and repeat that to whomever is doing the procedure. Also, make it clear before you start the procedure that you want it to stop at any given point you're not comfortable and that you want to remain in control of that.
In terms of the scan, they may do abdominal 1st, then transvaginal. Abdo is just cold jelly, and the device running over your abdo region, you'll need a full bladder. Transvaginal uses a slim probe, gently inserted with gel into the vagina and moved around a little to get the images. Empty bladder for that. No pain relief needed and very quick.
They may opt to do scans only first then have you return at a later date for hysteroscopy if they don't get enough info with the scan.
You are in control, if you don't feel you have enough info about what's going on, ask.
If you haven't used vaginal oestrogen since you started meno, it might be an idea to start it before the procedure if you have any symptoms of vaginal atrophy. Hope this helps, please ask if you have any more questions.