Has anyone ever had a cystoscopy?

I’ve been suffering from recurring UTIs since December 2024. It’s always the same bacteria. I suspect there’s a biofilm, and I’m already taking NAC, Kirkman, and Phase 2. However, I’m now scheduled to have a cystoscopy, and I’m absolutely terrified of it. I had an appointment a year ago, but I canceled it out of panic. But I want to get better, and I know there’s no way around it—I have to do it. I’ve only read negative things about it. Can you share your experiences with me—both good and bad?