I've always find them to be ok. Not fun but not painful.
I'm 50 and post menopausal now and had one on Friday.
Holy shit! It actually made me cry and I'm not one to shed a tear normally.
Is this yet another joy of getting older?
Thank god they're only every five years now (hopefully).