Interesting to me that the discussion turned to mechanical failures. I'm guessing you all are better divers than I am. My failures with these devices is exactly that, MY failures. Given my general incompetence, I'd suggest the SPG as backup is a good idea, at least at first.
My errors:
1. Forgot that my computer warned me that the TX battery was getting low. Yup, the next dive it was not just low, but nonfunctional halfway through. (And be careful if your computer tells you battery level: Some systems suggest the battery is full or nearly so, then appear to drain rapidly. Once it starts to go, replace the battery.) This was after using the computer for oh, 4 years or so.
With other equipment I've used (data sondes deployed underwater), my team learned that about 1 in 8 C batteries were defective out of the box. We learned the hard way, and henceforth tested each battery before use. Hasn't occurred to me, but might be a good idea to make sure that battery you're about to install has the rated voltage out of the box....
2. At first I didn't realize that I had to acknowledge a comms failure in order to see pressure again. Turned out the communication issue resolved pretty much instantaneously, but I didn't realize I had to press a button to clear the message and actually see remaining pressure. Now I realize the protocol, it's still mildly annoying when the TX temporarily fails. I don't realize it until I want information and then can't get it quickly. While teaching, I don't want to be futzing with my own gear, clearing an error.
Somebody earlier suggested dual transmitters and computers. I don't have a problem with that, though others note some electronics interfere with signal. Presumably such electronics could interfere with two transmitters. Never had issues with this myself, and I suppose if money were no object I'd buy a second Tx/computer setup.
FWIW, I route the SPG under my left arm and pin it tight to my BP/W at the waist strap. I can glance down and see it easily if my hands are occupied. I suppose I like it as streamlined as possible, so not over the shoulder. But if the hose length were perfect I could see routing it to the LPI hose for the BCD. Never thought about it, but it could also route with a dry suit hose.
I don't have enough experience to know whether the SPG or computer is more likely to fail, and I've not seen data on this. My 37.5 year old SPG still seems to work, though I don't dive it any more. The only computer failure that wasn't my fault was a pressure sensor going bad, giving me faulty depth. And that happened while driving home on a highway.