Should I do this uretheroscopy?

The date is getting closer and closer to to a procedure I don't even know if I'm sure I even wanted to do. One time I had a burning feeling day long while I peed, and ended up in some blood After the last time I Urinate. Never had any symptoms again. Then two months after again the same feeling, just a couple of drops of blood at night and that's it. After my CT scan my doctor found a small Filling Defect, he want to do an uretheroscopy with a stent placement to do a proper check up and biopsy of that irregularity. And I'm honestly traumatized and by now even I'm starting to feel cramps, weird sensations in my flank, and irritation even before the process, just by reading all the horrible stories you guys are telling online.

I really want to understand if I should do this process, and if I really do... how can I manage the most possible, my pain and my recovery and minimize my suffering to the max? I'm 34/ Male who exercise oftenly, I'm vegan and also usually drink a lot of water and eat pretty balanced. I'm super scared of going through this horrible pain. And I want to avoid it at all costs, but I need some encouragement and good stories, all I read is horrible, painful, sad, miserable and traumatizing....