HCPs need to believe women if they say that find the procedure painful.
I'm 40 and have always gone for my smear test, albeit sometimes after a second letter prompting me, and have always found them painful. Not embarrassing, actually painful. I'd been referred to hospital in my 20s for pain while attempting penetrative intercourse and inserting tampons (which was never resolved), and later had investigations because of infertility (TTC despite the pain) so was no stranger to being examined.
I've not had the same person do one twice for me, have had them done by nurses, GPs, at surgery, at a young persons sexual health clinic and each time I've not been believed, and they seem surprised when I'm crying quietly, bleeding or instinctively trying to climb off the bed away from them. More than once they simply couldn't get a sample. I'm not normally an anxious person or prone to hysterics. On some occasions I've bled at the time, and/or later and found sitting down uncomfortable for days afterwards.
Finally got it sorted a year or so ago, following a referral from my GP who was unable to get a sample despite several attempts with the smallest plastic speculum in the survey. Had a smear done while under general anaesthetic for surgery for Fenton's procedure. When I came round the consultant said they didn't actually do the Fenton's, and instead removed bits of hymen. Once healed it's made a huge difference and I can finally have pain free sex, and I anticipate that my next smear test shouldn't be anything like as difficult and distressing as all the rest were.
I realise that my experience isn't likely to be representative, and my difficulties turned out to be because of an underlying problem. I don't want to put anyone off of going for their smear, but I'm annoyed that this took the best part of 20 years to resolve, almost taking my marriage and hopes of motherhood with it. It took so much courage for me to seek help for this the first time, as a young newly wed, and to be met with such scorn, indifference and disbelief put me off pursuing it again for years. You only have to read threads on here and elsewhere about difficult births to see that women are routinely ignored when trying to advocate for their own health.