I've had many rounds of Botox. It helped me a lot - much less pain, much less urgency. It did not completely restore my continence, but it improved it.
I ended up having to cath after Botox. I didn't find it difficult, and after the first few days I didn't find it painful, though it was sometimes (though not usually) uncomfortable.
I haven't had Botox since last August because I got an Interstim, which has taken care of most of my issues. I may yet need more Botox, but so far I've been able to avoid it with programming changes on the Interstim.