A MSW gives you the most options when it comes to jobs. You can work in private practice, hospitals, non-profits, agencies, schools, VA, etc. I will likely being attending UNC-CH that has a specialized direct practice curriculum in the final year. I've heard that people have to learn modalities outside of classes... most MSW programs do not teach modalities. MSW degrees allow you to step away from private practice/therapy/counseling if you get burnt out. If you specialize in counseling, then that is what you'll stick to.
I'd reflect on what is best for you and then proceed.