Cystoscopy or bladder scope

Has anyone had a cystoscopy aka bladder scope done? Was it painful? What was your experience like? Was it super awkward? I'm supposed to get one done next month and I'm super nervous about it and also feel really uncomfortable about a male doctor doing it but I don't have a choice really.