Are there any of you that continued therapy after a hurtful termination and found it to be helpful? I'm bouncing back and forth between "therapy is awful and not helpful" and "I absolutely need help."

I don't know how to find a therapist that will really, truly work with a client with persistent suicidal ideation and not be burnt out by me. So many therapists say they work with depression and SI, including my last therapist, but end up terminating with me when they see they aren't making a dent. Is therapy even helpful for SI? I don't know what to do.