I believe an unsedated colonoscopy experience would be synonymous with an unsedated flexible sigmoidoscopy (which I've had many of in various stages of inflammation).
If you're in remission, sedation is likely unnecessary and you'd be equivalent to a healthy person. However, if you're badly inflamed/flaring then it's going to be a painful experience. I was flaring badly and had a reflex reaction during a flex-sig where I intended to reach back to pull the scope out, luckily, the assistant pinned my arm down as soon as she saw motion. So, if you're symptom free then you could risk it and go for it unsedated. But, if you have any less than minor symptoms then get the sedation. I recently had a flex-sig (where I was confirmed in endoscopic remission) and there was minimal discomfort, mostly from the air they puff in.
Anyone owe you a favor? Ask them to pick you up afterwards. Or buy a neighbor, friend, family member, or coworker lunch as repayment for giving you a ride home, or something