Given the time investment, cost, and limited benefit (from a financial perspective), it's hard to recommend if you don't plan on using it to prescribe. I did it long enough ago that it was less expensive and it met multiple needs for me (clinical, research, fallback plan). I'm just now looking to complete the process to get licensed, though that is mostly to give myself flexibility if/when I leave academic medicine.
I think for people who want to prescribe from the get-go should look at NPs or MD/DO programs….not because I think the training is better, but because the path to licensure and a comfortable salary is much more straight-forward. Given the limited areas for psychologist prescribing, a person would be limited to a handful of places where they could prescribe. For me (10+ yrs ago) I was okay with Louisiana or New Mexico, so it made sense as a fallback plan. There are more states now (IL and Iowa, with half a dozen other states kicking around legislation), but it is still quite limited in regard to geography.