MSW vs Mental Health Counseling?

Hi! I graduated with a BA in English in 2018 and have been in corporate ever since (sales). Due to some life experiences and change of heart I want to make a career switch into social work/addiction counseling. I’ve been applying or putting together collateral for MSW applications (Fall 2026 term) and actually submitted a few! After talking to one of my therapist who got a masters in Mental Health Counseling, I wonder if that’s a better fit for me? It seems a lot of the Counseling programs are in person or at least hybrid (which isn’t the end of the world would just prefer online but I’m sure they make it so you can still work) but also a lot of them or at least the programs I could afford and are interested in (SUNY/CUNY- I am based on Long Island) require 4-6 courses in psychology which I don’t have from undergrad. My minor was sociology. I wouldn’t mind going to community college and taking these courses then applying for the Fall 2027 term just not sure if it’s worth it if an MSW would be better (more opportunities post graduation) or just as good of a fit. Based on my research if I received my MSW and LMSW I could still qualify for a LMHC license?

I know that was a lot. Before I commit to a MSW program and invest, I want to make sure I go back to school for the right program. I ideally want to be a counselor/therapist specializing in addiction.