I had it a few years ago. They inserted the camera via my nose so I didn't get the gag reflex thing at all.
They performed it under a local anesthetic so no pain, but it's not a very pleasant sensation. Nothing to worry about really but given a choice I'd prefer not to have to go through it again.