Patients with neurological conditions “falling between the cracks” in Scotland’s health system, a major new report has found.