Colposcopy + Biopsy Pain

Hi all. I’m waiting for the results of my pap/hpv screens. Depending on the results, I might need a colposcopy with biopsy. My doctor offers a local anesthetic via shot in the cervix (sounds terrible). She mentioned that some women state that the shot is way worse than the procedure itself (those who have done it both with it and without). I’m looking for some advice based on experience, whether you feel the shot is worth it or if the pain of a biopsy is relatively tolerable? Thank you so much.