Just had one done a week ago. (yeah, there you go for recent) The worst part is the prep work. Just take that whole day off. And I won’t lie it sucks. But I mean, get a good book, or laptop in the can with you, and stock up on jello. And really it’s not a whole day if you don’t include the fasting. Sure you can’t eat, but you get over that. Then at 4pm you start drinking the 4 liters of liquid, and you drink it fast. 8oz every 15 mins is no joke. It’s like, glass, bathroom, and then right back for another glass. Then another 4 hours to make sure it’s all out of your system. Then you go to sleep. So yeah, a really bad 8 hours, but not the worst in your life.
The actual procedure is done (at least I was told) in a way that you are not actually out, but you will have little to no memory of the procedure. I have a few flashes of memory of the procedure, but nothing clear really.
All in all, a crappy day (no pun intended) but it beats what they would have to do if you start to develop cancer, or have an undiagnosed bowl condition.