Wish I could add to the butt jokes but it's not my strong point. (My H would be a real asset here.)
I had a colonoscopy a few years ago and the procedure itself was not a big deal. The prep is a pain - the day before make sure you are at home from 3 or 4pm on and not far from the bathroom.
As for the procedure, they should offer you a sedative - take it. (A friend didn't take the sedative because he wanted to be able to drive himself home right after - he wished he had). I was awake during the procedure but felt loopy, kind of drunk - nothing seemed to matter. It was not painful. I didn't mind watching it on the monitor but that's your choice. I must have fallen asleep during part of it because suddenly I was in recovery.
Get someone to drive you home. I assume someone will be taking care of your kids during the procedure - would be nice if whoever could stay when you get home, in case you want to sleep.
All the best! Doglover
There are many wise, empathetic and funny people here: you are my buddies - I'm grateful for your support.
here.)