Here we go... this is one of the most confusing topics in psychiatry because people fail to understand the historical background and evolution of criteria. Most people just regurgitate what their attendings tell them or what is in most standard textbooks (unfortunately influenced by Max Fink who is obsolete). But it's always good for me to pull out the classics...
So, the syndrome was originally defined by Kahlbaum in
die Katatonie oder das Spannungsirresein in which Kalhbaum describes the illness with psychosis, mania, and melancholia, but focuses on the motoric signs because he was comparing this to General Paresis of the Insane (neurosyphilis for all the neophytes tuning in) and this is how, even prior to Kraepelin, he focused on the illness in terms of
longitudinal course. Kraepelin then defined the dementia praecox as the core illness being a destruction of the emotional and volitional spheres of psychic functioning ultimately defined by a terminal state ranging from weak mindedness to profound dementia, where the catatonic syndrome was a variant of the DP (along with paranoid and hebephrenic, reflected in earlier DSMs). If one reads Kraepelin closely (which was required for us as interns), you note that nearly 50% of his patients he called "catatonic" began "in a state of depression" and noted a relapsing course of catatonic stupor and excitement (which is what he thought Kahlbaum meant when he said "mania" though Kraepelin's description of catatonic excitement sounds like actual mania). Either way we would see a strong affective component if we could be transported back to Kraepelin's asylum in Munich and without knowing the terminal state (and having meds at our disposal) we might call these patients Bipolar or psychotic depression.
If, however, you read Kraepelin's
Manic Depressive Insanity and Paranoia he clearly describes constellations of symptoms that today we would call "catatonia". It is nonetheless a conceptual error to think that people with bad depression become so psychomotor slowed that they just become "catatonic" (and this si when people imagine flexibilitas cerea without actually knowing what it means). A true melancholic catatonic stupor is something entirely different and they will meet the symptomatic criteria.
The idea that catatonia is more prevalent in affective illness comes from a classic paper by Abrams and Taylor
Catatonia. A prospective clinical study. - PubMed - NCBI where 62% had BPAD, 7% had SCZ, 9% had "endogenous depression" and 16% had "coarse brain disease". Notably they used their own criteria (one of our older attendings collaborated with them a long time ago and admitted that A&T tended to over-dx mania) and defined catatonia by "one or more of the following motor signs": mutism, stereotypy, posturing, cat¬ alepsy, automatic obedience, negativism, echolalia/echopraxia, or stupor, as defined by Fish." But you get the idea, and DSM V is probably more "correct" in defining catatonia due to a distinct syndrome.
If you also take Kraepelin's hypothesis of catatonia as an "end stage" of psychosis (complete destruction of the volitional sphere), the differential prevalence could also represent the fact that we treat most schizophrenics (i.e., we don't let them get that psychotic) and that in affective illness the morbid process might be somewhat different (but again- at the end of his career Kraepelin was unconvinced that his dichotomy "carved nature at its joints"
In terms of current nosology the best paper is by Peralta and Cuesta, who are some of the clearest thinkers in terms of phenomenology based diagnoses:
Motor features in psychotic disorders. II. Development of diagnostic criteria for catatonia. - PubMed - NCBI They meticulously drew from the various descriptions the most consistent symptoms and then culstered them, producing catatonic and non catatonic groups. They found that all catatonic subjects met at least 3 of the criteria. Unfortunately the didn't label diagnoses beyond that schizophrenia was more prevalent in the non catatonic grouping.
As far as other illnesses- yes, you can get catatonic-looking syndromes, but is it the same? Maybe for anti-NMDA encephalitis/PCP intoxication since this is reasonably well described and mimics SCZ psychosis. The literature on everything else is so poor I'm not convinced it's the same syndrome (or if the raters knew what they were doing when the used the BFRS). Autism is an interesting case- Bleuler of course consider "autism" to be a hallmark attribute of schizophrenia and we know the shared genetic overlap/epidemiology/etc etc etc. Some of our child attendings are world renowned autism experts (in genetics, epidemiology, and neuroimaging) and said that they believe that this is a true catatonic syndrome (interestingly it happens in some of the higher functioning, formerly Aspberger type patients)