Sorry your experience with Cysto has been such a nightmare. My first was indeed VERY uncomfortable and painful at times, in part due to an enlarged prostate and my inability to relax. With experience (I know what to expect) and coaching (being reminded to relax, breath deep, wiggle toes) I've found subsequent cystoscopies much more tolerable.
I'm curious: your age and country of residence?
I've had 2 TURBs in an outpatient surgical center, while under sedation. However after the last TURB, my urologist said that at the next cystoscopy, if he sees any unusual growth(s) he will probably remove them at that time, in his office, rather than scheduling another procedure at the surgery center. I'm admittedly not looking forward to that as I prefer to be sedated. He reminded me that there is risk associated with sedation. It's a trade-off.
I ask my primary care physician to prescribe 5 mg diazepam (valium) prior to each cystoscopy. It helps take the edge off. Also, I was granted a medical marijuana card. I live in New York State. With some experimentation, I've found a small dose of 50/50 CBD/THC mix helpful, especially with dysuria that occurs for about 6 hours after expelling BCG. It doesn't take the pain away. It does makes the pain "different" and slightly more tolerable.
I hope your most recent cystoscopy was more tolerable and I hope nothing out of the ordinary was found during the procedure.