I'm female, so my experience will likely be different than yours, plus I had mine 20 years ago, but I wanted to make sure you got an answer before you left to get it done.
Here's a pretty good description of it - https://www.nhs.uk/conditions/cystoscopy/what-happens/
You are pretty numbed up, because they'll numb your urethra. A lot of it is uncomfortable, but not really painful. You won't feel the camera - which is a very strange idea when you think of it, I know - and probably the most you'll feel is a full bladder.
Ask your doctor all the questions you want to - before, during and after - and make sure you know what to expect after, like what's normal after based on what they did.
It won't be your most pleasant experience, but you'll be okay. :) Let us know how it goes.