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.
I have one pretty much yearly. You have to make sure not to eat the wrong things (like seeds, nuts) several days before and then the day before eat very light food and stop around noon. Then take the laxatives in the evening and again the next day about 4 hours ahead of your procedure.
The worst part to me in all of this is really drinking that cup of laxatives. The sedation (for me) has always been dosed well enough that I feel fine within 30-60 minutes after waking up. Although you can't operate a car or other machinery for the rest of the day. But I also don't have to work on those days, so it's a relaxing day to me.
You can actually schedule it so that you simply pull an all-nighter while taking the laxatives. That way you'll be cleared out by the time of the colonoscopy but only really just spend 1 day dealing with the colonoscopy prep and procedure. (You'll still easily want to sleep normally after)
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.