It's weird that you would state that so confidently when, as wikipedia says, "Hoffer's ideas about megavitamin therapy to treat mental illness are not accepted by the medical community." It didn't pan out.
Didn't pan out because it's not the plan to pan out. The plan is to make people think there's something wrong with them and recycle them with insurance.
It didn't pan out because attempts to replicate it didn't work. He seems like another LSD abuser who thinks every idea they have is good or maybe a grifter who wanted to maintain interest in fruitless theories.
Enzymatic cofactors (vitamins) many not a be cure, but maybe a better, cheaper, less harmful, treatment. Take pyridoxine (B6) as an example.
Also, did you know vitamin C deficiency not only casues scurvy but mood disorders as well?
The neuropsychiatric effects of vitamin C deficiency: a systematic review
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC7302360/
Vitamin B6 as add-on treatment in chronic schizophrenic and schizoaffective patients: a double-blind, placebo-controlled study
https://pubmed.ncbi.nlm.nih.gov/11838627/