propofol vs conscious sedation

Does a colonoscopy hurt? Honestly, the prep is the hard part — sedation keeps the exam itself comfortable, and most patients don't remember it.