It really only makes sense in case where the President had a stroke and literally could not function at all.
I respectfully disagree. They considered all sorts of situations in which they thought it would ba appropriate for the VP and Cabinet to invoke it. Kidnapping, treason, drug abuse, psychosis, even laziness and dereliction of duty. Of course, this would likely end up being decided by Congress.