Went to gynaecologist a few years ago for initial consultation and he whipped me into an examination room and proceeded to take a biopsy from my womb with no anaesthetic or prior medication. It really was no worse than having a vaccination, perhaps better because I had no expectation/anticipation of what was going to happen.
Having said that, a few years later I had the whole works - a biopsy under general anaesthetic followed 10 days later by a hysterectomy because of cancer of the womb! And the latter was a doddle - key hole surgery , 24 hours in hospital and home!
PS Am a total wimp - on edge at moment of writing as am due at the dentist for a filling this afternoon!!