This is a natural concern when getting a cystoscopy.
The level of sensation you have during a cystoscopy will vary depending on various factors mentioned above, such as the type of cystoscopy and the anaesthesia you are given (as highlighted above).
If you are under general anaesthetic, you will be unlikely to have any sensation during a cystoscopy, and so the procedure is unlikely to hurt while its underway. However, you may have some discomfort after the procedure is complete. General anaesthetic can also make people feel unwell for a time once they are awakened.
If you are only given local anaesthetic, you may still have some sensation during the cystoscopy, which may burn slightly or feel similar to urinating, but your sensation should be substantially reduced.
If you are concerned about this, make sure to discuss your options with your doctor and get clarity from them to reduce stress and concern.