What is the threshold of missed prayers under inability to gesture, or insanity, that completely excuses the patient from making them up?

The Sick Person's Prayer (صلاة المريض)