Modern antipsychotics are useful for conditions beyond schizophrenia. Seroquel is commonly prescribed for insomnia at doses lower than those used for Schizophrenia. Adding Abilify is a common second-line strategy when first-line antidepressants aren't giving proper results. Certain patients with bipolar disorder benefit from antipsychotic medications, particularly in the therapeutic delay before traditional mood stabilizers can kick in.
Like you said, the drugs themselves shouldn't be demonized. They're not perfect, but when used appropriately they're often far better than the underlying conditions being treated.
However, if doctors are simply making up diagnoses in order to prescribe the drugs, that's obviously not appropriate treatment.
The second generation "atypical antipsychotics" are really not much different from antidepressants. They just typically contain an additional dopaminergic effect (e.g. modulation). As someone else pointed out in this thread, Abilify is prescribed for depression and anxiety.
The issue is as you note in this instance, their use for something otherwise, that is, to force submission to make others' lives easier. It is not just in care homes that they are used for this purpose. Psychiatry as is practised within institutions such as prisons, schools, or care homes, serves as a way to legitimize dealing with difficult people using forced or coerced drugging, something we would not otherwise accept on the face of it. I don't see any good solution to this issue, especially not in the case of a care home where many residents will be deemed by all to not have capacity. Oversight can only do so much and when there are loopholes like the three excepted diagnoses mentioned in the article being exempted from public tallies, incentives will do the rest to close it.
EDIT: I'd like to add I have considered a bit more about other people I know who have taken or are taking antipsychotics (voluntarily), and they have never expressed extreme distress at their side effects. So I should have said 'can have' rather than 'have', my initial wording being influenced by my own experience.