I had a colonoscopy + upper endocoscopy a few months ago, age 29.

The prep was horrible, particularly the electrolyte drink they make you take the night before. I almost puked several times trying to get that stuff down.

Actual procedure was a breeze. I was sedated, and then I woke up and it was over.