I've been searching around for information on colonoscopies since my somewhat disturbing experience and thought I'd post a quick follow-up. It looks like pain during colonoscopies isn't that unusual at all. Contrary to what most doctors and online accounts of the procedure suggest, it seems that there are significant numbers of patients who don't tolerate them very well.
This synopsis was interesting:
http://www.ncbi.nlm.nih.gov/pubmed/12048623That plus most of the other literature I could find online indicates that the most common point of pain, and reason for failing to advance the colonoscope deep enough to complete the exam, is a loop in the sigmoid colon.
The reason I got interested in all this is because I requested a copy of the post-procedural report from my GI doctor today. In it, he indicates that I was very sensitive to the exam, and that at about 60 centimeters (roughly 24 inches) from the anal opening, he encountered a "very sharp and twisted turn" (those are the words verbatim), which is where I started screaming in pain and they had to discontinue.
I still don't like the fact that we weren't able to visualize the entire length of the colon, but am somewhat comforted by the knowledge that colonoscopies aren't a walk in the park for everybody, and thought I'd post this in case anyone else has had a weird experience with them before :)