Endometrial Biopsy: I’m terrified, what can I expect?

Hi there, I have no bleeding but my endometrial thickness is a 6 and I have an endometrial biopsy scheduled in 30 days and I'm terrified. I made the mistake of reading all the horror stories on the internet. My doctor said it is painful and is preparing me by asking me to take VagiFem 10 for the next month and also to take advil before arriving. I've had pap smears all my life and they never hurt but my last one did. But I think that's because the doctor ( mine retired ) used a large instrument which hurt but then switched to a smaller one which was fine. It's a different doctor who will do the biopsy. I've had 2 transvaginal ultrasounds which didn't hurt and one hysterscopy which didn't hurt at all. But I'm terrified of the biopsy. My ultrasound showed a thickness of 6, nothing else, and my CT scan showed nothing. I wish my doctor hadn't told me it would hurt - when I said my last pap smear hurt, he said this would hurt more. He wasn't trying to be mean, just preparing me. I'm hoping I can do it. Any thoughts? And thanks for listening.