I'm going through menopause right now, but haven't had a pap for quite some time. I don't have a doctor, so maybe a walk-in clinic? They're definitely not pleasant, but necessary.
Sorry you were in pain. They ought to have lubed the speculum ...
Hang in there!