Well, i have got a combination of neurogenic bladder over activity and retention at the same time. I do selfcath for some years now and still wear diapers most of the time, sometimes with a lot of pain on top for different reasons.
There are moments i wish it would just flow, but this is not really an option, as
@mickdl and Italuv already pointed out.
First: All doctors will try to get you "dry" in the first place, that's the goal, when there is obstruction, they will try to solve that problem, perhaps a TUIP or something like that, the goal is always, that you are able to keep dry and pee freely, when it is not possible to get you to pee easy, they will choose ISC (CIC) over incontinence all the time. When this all does not work, they will choose an abdominal wall catheter.
A friend of mine had just an operation last week where they reconstructed his urethra and changed the opening into the scrotum, he pees now like a women, all to enable him to pee. Doctors will do everything to prevent you from leaking or retention.
Selcath should never be painful, when it is bleeding, something is going wrong for sure.
There was something like a stent that opened up your urethra for some time, but this was not a solution for longer time and they stopped that technique for the most part. Incision is still done in some cases, but it has got its own problems.