I had a colonoscopy without any sedatives and I agree, the prepping was worse. Not eating for 24 hours was easy, drinking the solution the night before was unpleasant, and drinking the solution the day of was awful.

My pro tip would be to take the day off work. Trying to work while drinking the solution in the morning didn't really work.