I had it once, and I wouldn't call it a "mild inconvenience". It was basically two days for me, one to sit at home dealing with the laxatives, and another recovering from the sedation.
It wasn't excruciating, and it's sure as hell better than cancer. But I'm glad I don't need to do it again for another decade.