I had my first one last year and the PREP WAS NOT BAD!!!
I've had worse stomaches before. Prepare 'your room' for a few hour visit and get up and walk around in between ... don't just sit there. Luckily my bathroom is in the master bedroom. I shut the door, turned on the tv and got the business done!
I think a lot of it is your frame of mind. I can think of a lot of terrible things I'd rather not go through than simply cleaning out the colon. Heck - the 2 days of no solid food was worse for me cause I'm a 'grazer' when I eat.
LOVED the part where I could sleep off the anathesia for the rest of the day!
Good luck to all!