Hi Foxlee
Just to add to the above posters, I have had 2 colonoscopies and am on a 5 year repeat screening programme. (All well so far I'm glad to say).
The actual procedure is almost completely painless, a little discomfort is all that I would say, nothing to write home about at all. You can actually see what the Dr and nurses are seeing on a monitor (if you want to) and the staff doing mine on both occasions talked me through everything that was going on. I honestly do not remember any aftereffects either, so I guess there were not any.
I must agree, however, that the day before is not pleasant. I found that it wasn't so much the running to the loo that was bad, it was actually downing the sheer quantity of liquid laxative that I found quite unpleasant. The stuff does not taste bad at all, sort of sweet and vanilla flavoured but you have to down an awful lot of it within a certain time period. That was yuk, but definitely not painful.
The staff are so good too, that I didn't even find it embarassing which I thought I would. When I had mine, the Dr examined me internally with his fingers first. Again, not at all painful and over very quickly. By the way, I did not find the sedation particularly sedating, so was fully aware of everything that went on.
Chin up and I hope all goes well.