I had a colonoscopy a couple of years ago and I also had about 4 very small pre-cancerous polyps removed. I remember them giving me drugs....good drugs.... and don't remember anything until the nurse was helping me wake up. All in all the test itself is a piece of cake.

However I took the previous day off work because I spent most of the day in the bathroom. I have to agree that the prep is much worse than the test itself.