Why was my colonscopy extremely painful and I had have two doses of sedation?

Depends on the. Endoscopist, type of anesthesia and if you have had multiple abdominal surgeries, but with proper sedation you should not have felt anything. Sorry to hear your experience was so bad.