I had one years ago after finding blood in my stool.

The stuff to drink to clean you out prior was the worst part for me. That stuff was nasty and I had to choke two glasses down.

I was awake during the procedure and other than some cramping, it wasn't too bad.