First of all, that claptrap about taking two Advil? Garbage. Listen to me: get someone to drive you to the appointment, and take two VICODIN. Or four. Or, preferrably, try douching with lidocaine. (There's a potential digression here about the fabulous dentist I had as a child who would drip lidocaine instead of injecting it, but I'm going to stay on topic.) Please note that this advice comes from a girl who thought an HSG was painless except for about 90 seconds, and who totally refused morphine (or Vicodin) after her triple-header surgery with the giant incision (and two small ones). (I took ibuprofen and that was plenty.)

Why is this? Simple. I'm actually pretty tough about pap smears (and even ultrasounds, even when they really want to take a look at something that appears to be in another part of your body, such as possibly your head). Imagine they take the little speculum thing and ratchet it up to ALL THE WAY OPEN. I don't know if you're aware, but it has settings. The one they use to get a swab in there for a quick pap smear is nothing.
Then, since they're using a camera to look through the speculum at the cervix, they shove the speculum at all different angles to get a good look at whatever it is they find interesting. Keep in mind that this is a metal object, somewhat sharp (I'm not suggesting it's sharp enough to cut). They then go after the cervix with an assortment of swabs - one with vinegar to make the cells stand in relief (that's supposed to sting, but maybe like rubbing alcohol - nothing to write home about), others to assist in their investigations, and later, some with silver nitrate (to cauterize the wounds!).
By the way, this entire process takes over half an hour - maybe forty-five minutes. The full-on speculum for 45 minutes. Then comes the fun part: they take a sharp object (innocuously called a "curette." Apparently it's supposed to hurt less if they say "cutting instrument" in a different language) and CUT OFF PIECES OF YOUR CERVIX. After one of these, you feel as though you're done, so you'll be rewarded for your suffering. But no - they need to take a further look (more contortion of the speculum) for more areas they might want to attack with sharp objects (in my case, they wanted an assortment!). My doctor wasn't into the communication either, and so I would go from being in pain to being in LOTS of pain, with no warning. After I asked, more firmly than politely, I suspect, for her to tell me what she was doing before she stuck anything else in there, she really did give me more information.
The bottom line was, it doesn't APPEAR that I have cancer, or even carcinoma in situ (bonus!). It's a "low-grade" dysplasia. Generally, the protocol is to wait four months, check again, and hope that it heals itself (because I'm young and "healthy" - hahahahahahahahaha! - so it could just do that). Of course, in my case, it won't, because a year before I had the pap smear that led to this colposcopy, I had another, but less severe, irregular pap smear - i.e., it's getting worse, not better. If in four months it stays the same or gets worse (i.e., carcinoma in situ), then it gets surgically removed (conization or LEEP). I get the biopsy results in two weeks, and then I expect I'll be told to wait four months and have a minor surgery. It's always nice to know when your next surgical milestone is coming. (If I'm really lucky, I can add one for possible fibroids and another one for the endo soon too! I complain that my life is undirected without motherhood, but actually I have an aspiration: human pincushion.)
Also, for those of you who are really doing the math here, one question I asked this morning before I signed the consent form was, "Since I am almost (but not quite) at the end of my cycle, could this procedure cause miscarriage on the insanely remote possibility that I am pregnant?" The doctor didn't want to come out with "absolutely not." I guess, in fairness, sneezing can cause miscarriage if you're unlucky (or IF!). But they do perform the procedure on pregnant women. Given the vanishingly small possibility that I am pregnant, I considered this assurance enough. But my last piece of advice: if you're going to have a colposcopy (because your life lacks sufficient variety with all the shots, scans, and hormone pills), just to remove that worry, do it around CD 7-10.
AND TAKE VICODIN.