Colonoscopy itself is no big deal, you’re out for the whole thing!

I mean if you’re in pain, sure, do it.

Otherwise I recommend staying awake (do ask your doctor though). I had a blast looking so deep inside me, but I had no issues (like tumors or inflammation) and the awful drink actually cured my constipation (the chronic constipation being the reason why I had colonoscopy in the first place).