My one and only sigmoidoscopy was only done with a local in the doctor's office. No fun, but not painful. Sticking a scope up to look at urinary system, up to the opening from the kidney, hurt. Then. And. Later.