I had one back in August. The prep was hard... I was sitting on the toilet for about 6 hrs. I only drank half of the orange flavored gallon of stuff, but I knew that was enough.
After you're cleaned out, drink something salty, like chicken broth... so you don't get too dehydrated. The next day, when I was to have the procedure, I felt very weak and shakey. This may sound wierd, but I would eat a little salt and sip water... even if you aren't supposed to.
Once they got the IV in me, I was fine. The sedative was nice
I woke up at home basically, and wasn't sore afterwards.
Keep in mind I was 100 lbs and 26 yrs old. I'm sure everyone is different. $800 to find out nothing major was wrong.