Just wanted to hear from anyone who had a flexible cystoscopy. Is it horrible / painful, and did it cause irritation / other side effects?