Have you tried the external condom type catheters? This type reduces irritation to the bladder lowering the risk of infection, also an irritant and thereby bladder cancer. Of course it’s important why you need a catheter. My Dad was paralyzed and used both external and foleys and was thinking about a superpubic but never had it. If you choose a superpubic there may be an increased risk of bladder cancer. Caution also must be taken not to insert the catheter to deeply. You want to avoid damage and irritation to the bladder and accidentally going into the urethra. Infection is a concern and some say sterile gloves aren’t necessary but I always used them. Infection does seem to be less with the superpubic but that depends how careful the person is who puts it in.
Usually more comfortable than urethra type.
Easier to have sexual relations.
Usually lower risk of infection.
Accidents or damage not as common.
Procedure is reversible if you go to a different type.
Larger catheters can be used.
You’ve got options.
Use bag or drain directly into toilet.
Sensitivity, might become hypersensitive in some people but in some it may go away. The site may be uncomfortable.
Not a good option if overweight.
Possible discharge at site.
Risk for infection.
Higher risk of bladder stones.
The site may begin to heal/close.
I wish you luck whatever you decide. Health and happiness,