I would really be careful about PsyD programs! Most are not funded, so you'll be in massive debt. Ideally, if you want funding, the PhD is the way to go, but since you're not interested in embarking a research career, you can pursue your MSW or an MFT, become licensed in your state, and start your own practice (or work in a different setting, like a hospital). If you're mainly interested in just practicing, then I recommend going to get your social work degree and becoming a licensed clinical social worker (LCSW). Plus, there are a lot of state schools that offer affordable MSW programs.