A key ambition for the treatment of seriously ill mental health patients has been missed, with some parts of the country falling short by a large margin.