The answer to your question is no. Psychiatry as it is and I think within our lifetime, will remain a non-procedurally oriented specialty. While nobody has a crystal ball, I predict the likely future "procedure" that can be billed for more involves things like medication assisted psychotherapy, ketamine infusion (and other drugs) protocol in acute suicidality, etc. as opposed to transitioning psychiatry into surgery. And even if things like say endovascular intervention for depression emerge, specialties like IR/neuroIR will get the first dip of the pie (as they should...what do we know about blood vessels and catheters???). I do see, though, if DBS becomes more prevalent in refractory suicide/OCD, psychiatrist would learn how to adjust the modulator, like neurologists for Parkinsons and essential tremor. But this is very different from actually performing the surgery itself.
But the idea that the future of psychotherapy, especially intensive, "brain based", pharmacologically assisted, imaging guided, "virtual reality" enhanced, etc. psychotherapy would be a "procedure" that would require a medical license is not that far fetched in my opinion (i.e. maybe within my lifetime). Nor is very specific imaging procedures, say reading SPECT for designing depression medication regimen with computer algorithmic assistance. I think if they can demonstrate real cost effectiveness, Medicare would be willing to allow for charging new procedure RVUs for these. But as it is, these are essentially research programs, not clinical practices. So, to answer your question, if you are interested in DBS, you should look for a program that has a strong DBS research group (i.e. Mount Sinai), as opposed to a big neurosurgery service.
Meanwhile, you can always carve out a niche doing only ECT. I've seen a few attendings doing this. Although if money is your thing ECT doesn't reimburse as well as you think it does.