Katejo, I've had 3 hysteroscopies - the first under GA (but only because they also did laparoscopy & D&C), 2nd with local and sedation. Both of those were done in fertile years so that area was reasonably robust & access easier.
The 3rd was 4 years postmeno with poorly managed VA & as it turns out an atrophied uterus - so there was nothing for them to sample on biopsy. That was without any local or sedation, because the NHS had stopped offering any sort of pain relief or sedation for the procedure by then. I took painkillers beforehand as advised, but felt no relief from them. Like yours, it was shockingly painful & tbh felt barbaric, though over very quickly with few after effects. The nursing staff were very kind & obviously felt bad it had to be done that way.
Of the 3, the least problematic by far was the 2nd with sedation & local - I'd wanted to avoid GA which makes me very sick for a long time afterwards. The anaesthetist was standing by to put me under if need be (those were the days) but I felt no pain. So if this combination is available for you, that might work well.