You will be sedated during the procedure. The preparation is the uncomfortable part.

As a general rule you will be directed to a doctor of the same sex for the procedure. And of course, you can request a doctor of the same sex if it makes you more comfortable.