There are differences of opinion about how big the spare air bottle would need to be.
There are only two sizes, when it comes to redundant/emergency gas:
Sufficient and
Insufficient.
We can argue hypothetically about the scope and nature of the emergency to be dealt with; limiting that scope/nature would permit a smaller bottle to be carried. Increasing the scope/nature has the opposite effect. None of those hypothetical discussions have any bearing on the risks you are exposed to - how, when, where or why Murphy might join your dive and try to kill you.
Most opinions start with an initial premise that you plan the redundant capacity based on the need for a safe, normal ascent, accounting for your SAC/RMV versus the dive depth (and/or overhead obligations).
IMHO, it is reasonable to conclude that there is little point 'prolonging' the emergency by planning for an emergency ascent, rather than a safe, normal ascent; which rules out the smallest capacity cylinders ("spare air" and tiny ponies) for most divers.
I believe it is also reasonable to account for a less than idea response by the diver. Emergencies, in most cases, do cause psychological and physical stress. That stress causes errors to be made...and causes psychological and physiological responses in the diver, for instance; the respiration rate accelerates and problem solving capacity deteriorates. I feel it is prudent to anticipate this and account for it within gas reserve/redundancy calculations. This anticipation requires us to account for more than a simple, direct ascent to the surface.
We need to account for the time it takes to recognize the emergency, to evaluate options, to choose a response...and to conduct that response. Under emergency stress, that time can be considerably longer than we might anticipate based on conducting a hypothetical scenario or training simulation. We also need to account for some time to rectify mistakes we might make; to recognize an error, re-formulate our response and put that into motion. Under stress, we can make mistakes.
We need to account for a less than optimum, timely ascent. The diver can start the emergency, or become, negatively buoyant (over-dumping)when OOA in their primary cylinder. They may have to surface using propulsion alone - raising SAC/RMV. Proper weighting therefore becomes critical; as does an ingrained skill to implement oral BCD inflation. Again, when stressed, mistakes will be made.
One factor remains constant.
GAS = TIME. That is true for
any emergency underwater. If the diver has
TIME, they can cope with mistakes, or slow decision making, or glitches, or ascent problems, or knock-on problems arising... or a million other variables that could otherwise lead to a terminal outcome; because
TIME = LIFE... and the purpose of emergency planning is to ensure we live.