At what point will SCRs reach the end of the line and CCRs then become the better solution? Can we expect to just throw bigger and more SCRs at the problem without increasing the risk? Are the scrubber limitations identical between SCR and CCR? I'm really asking, I don't know the details to come up with the answers.
What it really comes down to is :
Needed equipment for the task at hand.
A SCR is nothing more than a gas extender. It allows you to use a bottom mix, and not have to worry about po2 tox issues UNLESS you exceed your MOD. With twin hp 120's on your back, you could actually run out of scrubber duration and have a co2 breakthrough before you run out of gas (depending on depth). The scruber Limitations are based on your metabolic rate, and how much co2 you produce. Some folks can push a scrubber far, some cannot. The only worry is having a hypoxic mix in your loop, due to not enough "clean gas" being inserted on the constant feed. That is for me, the main reason that an o2 sensor should be on the unit. You need to know your po2, even if you won't tox, you can still pass out.
So in answer to your questions:
1: NO, SCR's have not reached the end of the line, nor should they. They are great tools.
2: CCR's are MORE APPROPRIATE in certain situations where carrying huge tanks is not optimal. They also allow you to go deeper and run your deco straight off the loop. Yes, SCR's can do that too, but they need other gear (Tanks, travel gas, etc...)
3: Do CCR's have more failure points than SCR's... Yes. Does the task outweigh the risk? Depends on the task. In some explorations, CCR is the only way to go. Alot of sites do not have picnic tables, drive up lanes, a sandwich shop, and a compressor.
IMHO, SCR's and CCR's both have their place. Some archaeological sites that I have been to WILL NOT ALLOW bubbles below the anoxic halocline. If you need to do that job, you need a CCR. For long duration, task loaded big cave exploration, a SCR is perfect. When I want lobster, I use an AL80. Just match the equipment to the job at hand.
Cheers