Yes, my experience is that psychotherapy for BPD can be very effective. I was fortunate to be able to do twice a week therapy for several years, and I've recovered to the point where I function and feel well most of the time; I don't have BPD anymore.

My favorite type of therapy is psychodynamic / psychoanalytically-informed therapy. Transference Focused Therapy would be one example of that.

Another good intensive therapy for BPD is schema therapy.

There's some data here on how effective they can be. It's pretty encouraging if you read through it closely and understand the charts.

JAMA Network | JAMA Psychiatry | Outpatient Psychotherapy for Borderline Personality Disorder: Randomized Trial of Schema-Focused Therapy vs Transference-Focused Psychotherapy