I've had a hysteroscopy (recently actually) done and they removed a tiny polyp at the opening of my fallopian tube and I was awake for the whole thing. There was not a lot to it, just like a pap, only this time they stuck a long metal tweezer type thing to pull the polyp off. But it was really tiny...hardly anything, which is probably why they didn't put me down. I've also had ovarian cysts that come and go on their own. Sometimes I've felt them (slight pain in the ovaries), sometimes I don't. It's all just a big pain in my patootie, if you ask me. I would just like to have a normal uterus...ya know?
Good luck to you! I'm sure you'll be just fine and be able to conceive perfectly well after the procedure!
~Jenn~ Mom to Ethan - my heart surgery survivor - born 6/29/09