I am replying to this old post but I hope it will help someone like this writer's husband.
I will have a cystoscopy tomorrow, under anesthesia. My second ever. This is because, like your husband, I found the first cystoscopy really shocking and painful, and administered in the same matter-of-fact way that you describe.
No more will I listen to this nonsense about "slight discomfort but quick" procedure. It seemed like hours. And haunted me for weeks.
So I insisted on light sedation or anything that would mitigate recall of what was the worst moment in my health history. Uro balked. Offered me Valium. I saw a anesthesiologist and connected him to Uro.
Most Uros are hardly charming, not noted for their bedside manner. Don't let them intimidate you into thinking a cysto is no big deal. It may be tolerable for some men, but not for most. And for me, it has been really bad. The Uro does not want to take the time or book the room where sedation can happen. Insist. Call your insurance co. Get a note from a psychologist. Anything to get asleep for the cysto.
So I go tomorrow, but with anesthesia and the peace of mind that I won't have to replay the assault for weeks to come. Then another round of BCG. When the world returns to some health post-COVID, I plan to dump the Uro and search for a healer rather than a brilliant plumber. I wish you courage in finding a good one as well. Hang in there.