I've tried both the single use and the foley. I don't need them; I was using them only for the diaper part. True, it is slightly uncomfortable inserting them, but it was a lot better than what I had read. You need a moderate amount of lubricant (KY for me).
The time I tried a foley, I relieved myself, put in a catheter, diapered myself, grabbed a large soda bottle, and went into town to run some errands. I was soaked in no time! That was a really helpless feeling! I didn't bring any diapers with me, and I was 20 minutes from home (I don't shop close to home in diapers!), so I HAD to buy diapers so I could change myself. That was quite a feeling!
I did end up eventually getting a bladder infection (not from that trip, but another time), and those are NO fun. Be careful, and make sure everything is clean! Also, while cathed, drink cranberry juice, and I've read it can help prevent an infection.