I'm glad this went well for you, but please remember every woman's body is different. Every woman's emotional level is different.
For some women, it's no big deal. They go to the appointment, get it over with, and go home. For other women, their anxiety level is such, a sedative will help them. For still others, their pain tolerance may be low, so they may need an IV drip in-office or general anesthesia in outpatient.
It's important for doctors to find out a woman's pain tolerance and her anxiety level so that it will be as easy for her to get through as possible. Of course women are frightened! They don't want disease, but they also want to make sure they won't be in pain.
Something to keep in mind is that women also need to make sure their doctors are experienced. I watched a medical teaching video about how to do a LEEP. It only takes ten seconds to remove part of a cervix. So, if the doctor is not experienced or is in a rush, mistakes can be made that will have enormous impact. This is why it is critical to not only educate ourselves about what we have and what all of our options are, (Our doctors are required to do this, per regulations.) but we must also research our doctors. Women are socialized to passively trust too much. When a woman is fully informed and her doctor proves trustworthy, it also gives a woman more confidence in her doctor, which will help the fear.
As an fyi, I have definitely been cautioning women to not go to the doctor who botched my LEEP.