Hysteroscopy under local anesthetic

Segolene

Has anyone had hysteroscopy under local anesthetic? I read horrific stories about women in such agony that they vomit, head spinning and fainting and having worst pain than even than childbirth!

How can it hurst if you get local anesthetic?

It would be good to know. Please can you kindly share your stories