These include psychodynamic therapy and Freud's famous psychoanalysis, existential-humanist therapy and Roger's client-centered focus, and behavior and cognitive therapies.
Like the psychodynamic school, existential-humanistic therapy is still insight oriented, but it's much more about promoting growth rather than curing illness.
And although Freudian theory is now mostly abandoned, some meta-analyses have shown that psychodynamic therapy can be effective, at least depending on what you compare it to.
Similar to psychoanalysis, psychodynamic therapy focuses on helping people gain insight on the impact of unconscious internal forces, early relationships, and critical childhood experiences.
Brief psychotherapy aims at the continuity of the patient's development that has been stymied by the emergence of a psychodynamic conflict affecting the life course.