DP has one and he's found it really great?much better than the indwelling or the intermittent (he could never manage that at all tbh). If you get one with a flip-flo valve instead of a leg bag and maintain your bladder tone, you can wee normally instead of having the valve open to a drainage bag (strapped to your leg, which is grim).
His infections went way down after the supra-pubic went in. If you get one, ask for a G-Strap but don't use it all the time (and not on a plane). You can tape the tube to your side with mefix (the best tape--other strapping gives you blisters), too, or some people just tuck it in their waistband?it depends how sensitive you find movement.
If it gets blocked, you can get Optiflos on prescription (a sort of squeezy bottle of sterile water) and they normally clear it out pretty well.
So long as it heals, it's perfectly clean. You can get sterile spigots that are very slim. If you replace the tap with the bung and put a rouched cossie on, no one will know if you want to go swimming. You can also get big waterproof sticky covers to cover the whole thing if it's not completely healed/weepy (they have these at hydrotherapy).
You can still have sex. No idea about pregnancy. District nurses will fit a new one, or you can go to clinic, or if you're very hands-on you can ask to be taught to do it yourself.
DP was very very leery of having it done and carried on with the indwelling for ages, which caused loads of probs, but since 2003 he's had the supra-pubic and it just removed a giant chunk of stress from his life. Big improvement.