I had a hysteroscopy, biopsy and Mirena coil fitted last December (Mirena - best thing I ever did, by the way!!). I had a local anaesthetic in the cervix as it needed to be stretched to allow the hysteroscope in (the gynae who did it said it's tight and scarred from my daughter's birth, but normal) - that stung a little, but wasn't painful. The procedure itself was quick and, for me, painless - it was over before I knew it. On the advice of the clinic staff I took paracetamol (I'm allergic to anything else) and rested for the rest of the day, but I really could have gone to work - I was absolutely fine.
The thought of what the doc was going to do was far worse than the procedure itself!