I had a colonoscopy twenty years ago with the traditional drink and twilight sedation, but when I had a false positive Cologuard test (I forget now if it was one or two years ago), instead of the drink I had the option of pills and water (I think the pills were more expensive/less covered by insurance). I chose to do the pills and water, it was still a lot of drinking and the toilet experience seemed to be the same either way.
I really wished I'd bought some adult diapers because after a night of no-warning trips to the bathroom (and having to do a load of laundry from not running fast enough), I had zero confidence that it was safe to not have a diaper. I wound up padding my underwear with lots of paper towels and carrying a towel to use on the seat of the car. Nothing happened but I still wish I'd had the adult diapers just to avoid worries (and if I'd had sense to use one from the start of taking the pills I could have avoided the middle of the night laundry chore).
The food prep days turned out to be enjoyable because it was an excuse to eat those little saltine 'oyster crackers' and white rice and all sorts of normally avoided refined carbs.
I stressed the most about getting a ride, a friend would have offered except she had a procedure the same day, and I found out my county has a site to find a free volunteer driver, but I didn't have enough days to be sure I'd get a ride that way (I think registering on the site would take a week or two but my procedure was in less than a week).
Luckily a person in the next building advertised driving jobs in our community paper and so for $45 an hour he took me and waited for me and brought me home. It wouldn't have been possible to pretend I had a driver because they would not start the procedure without the driver being in the waiting room (tho they did let him go sit in his car).
I'd recommend a little desitin ointment on the exit point during the toilet experiences.