Sounds like you should have had the sedative with the prep lol. I've heard of some people getting nausea and other issues, I avoided that luckily (I used picoprep, don't know if that helped). I did wish I had a bidet at home rather than just toilet paper. Super soft my ass.
I didn't think the pill was anywhere near as effective at detecting anything and is not reccommended for colorectal cancer screening.
I just watched a short report in a science magazine on TV, must be 3-5 years ago now. In my culture things are handled in a more "classic" (if not oldfashioned) way, so even bitter salt would have been tolerated much better by my intestines, but i guess it wouldnt have been hard to get picoprep under a different brand name over here. The good thing is, i wasn't aware about my FM before colonoscopy, but it was soon diagnosed after some extra checks inspired by the colonoscopy results.