To some extent, yes, it can be an uncomfortable experience. I don’t think many people enjoy the thought of having something put up their anus. However informing yourself and planning out the procedure ahead of time will help mitigate some of the discomfort both mentally & physically. Experiences vary, some people have a very smooth experience without any hiccups, others are more difficult. It’s best to try to have an open mind and to not assume that the worst will happen.
Since the colonoscopies are done under sedation or local anesthesia you will more than likely not remember the procedure.