I've had nine colonoscopies, since my sister had colon cancer at an early age. (She survived.) To the woman getting it, there's nothing sexy about it.
Although it's improved in recent years, the preparation to fully empty the colon is unpleasant, the whole point being to give you diarrhea in the extreme. First you limit what you eat, then you stop eating to do the prep. At least these days few doctors have you drink a gallon of something so vile vomiting is common. The stuff I had to drink last month didn't taste bad at all, but it had the same strong result.
The hospital or clinic where the procedure happens is fully medical, by which I mean there's nothing sexy or suggestive about it. You get in a gown, they attach electrodes and a blood pressure cuff, and cover you with a warmed blanket that feels nice. Nurses start an IV that's just fluids (because you're really dehydrated), you meet the anesthesiologist and head nurse, both open to questions. I should have counted, but I think I dealt with 12 to 15 medical personnel, every one of them asking about my birthday and allergies. Eventually they're ready and wheel you into the room and have you roll onto your left side underneath your blanket. Anesthesia is administered, and the next thing you know, it's over and you're in a recovery room, coming back to ordinary consciousness, which the nurse recognizes immediately. They wait until you're no longer woozy or feeling out of it, then you get dressed and go home. When the prep is easy and the doctor's good, you're not even sore, just tired.
Once I regained consciousness during the procedure and I could see the screen. I said something, they gave me a bit more, and I was out again.