Large metropolitan areas, such as New York and Los Angeles offer the highest-paying salaries to mental health and substance abuse social workers. ... Top-Paying Areas for Mental Health and Substance Abuse Social Workers. LocationEmploymentAverage Annual Salary California14,970$65,020 Connecticut1,920$64,590 3 more rows Aug 17, 2020