I think the negative and totally inaccurate depiction of psychiatric care on TV and in movies is why people are surprised that antipsychotics actually really help most people who are prescribed them.

Yes. Also, the name "antipsychotics" is of no help either.

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.