Yes, I've had 2 hysteroscopies to have polyps removed, with local anathestic.
It was painful on and off, but I got through it. Had mild contractions and pain like period pain straightaway after but this soon wore off. Then there's usually bleeding for about a week after.
There's been lots of discussions and threads on here, if you search you can read them all.
Some ladies are really lucky and have little to no pain, then there's ladies who cannot carry on with the procedure as it's too painful