I had one once as I hate general anesthesia. It was moderately uncomfortable, you still do the bowel prep, then they blow gas/air up your rectum to inflate it, and scan you. You have to pass all that gas before the discomfort eases up.
My initial scan said I had diverticulosis, but a real colonoscopy years later didn't find that