Had a colonoscopy 8-9 years ago. No problems - versed/midazolam. Because it was at the hospital where I have worked for several decades, I knew both the doctor and the RN helping. Which was fine by me. Finished mid-morning. Short bike ride late afternoon. Don't do this at home, kids!
Will probably have one more in another year or two. For those not at high risk, a screening colonoscopy is recommended no more frequently than every ten years. Because there is a bit of a risk of unintentional harm from the procedure. Don't want the risk to outweigh the benefits. More frequently is fine if there is a medical reason.
__________________
Bacchetta Giro A20, RANS V-Rex, RANS Screamer