Having a cystoscopy on Wednesday. Anyone find it beneficial?

So yea, my doctor is out of ideas on my inflammation and discomfort after urinating and masturbating so he's going to do a cystoscopy. From anyone who has had one, was it helpful? I'm kind of hoping this is the final thing I need to do for this to heal, but should I lower my expectations? Also, what was your recovery like and did you receive any medical injection?