Colonoscopy itself is not that bad. They can sedate you so you don't have to experience the procedure.
The preparation is not so great with the bad tasting lemonade and then going to the toilet for a long time. But suffering through that is worth it compared to not knowing if you have cancer.