I've had 4 or 5. I've lost count. My dad was diagnosed with colon cancer, and they wanted to start me earlier than normal. I was wide awake through my 1st one. Not sure why, but I don't want to do that again. It wasn't painful, but just not something I want to experience again. I thought my guts were going to explode when they filled me with air, and I could feel the probe moving through my colon.
The next 2 or so I was out most of the day from whatever they used. They used propofol on the last 2 and it was a much better experience. I woke up relaxed, refreshed, and ready to get on with my day.