Just wanna' know if I should stay on the Foley or re-try a bloody self-cath method.
I'm pain-adverse.
First; Getting information about the use of catheters, even from urologists can be difficult. I suggest asking different urologist offices if they do the Urodynamic Test (for bladder pressure). If an office does that test, that would show that the medical practice deals with bladder dysfunction and you could get expert advice about that.
Second; On this site here is a discussion about living with a Foley Catheter.
Third; I understand that using the self catheter can be painful (I know from personal experience). Still, you might find this discussion about the self-cath method useful.