It seems there are other issues here but regarding insights, it is not a therapist's job to give answers or have insights about us. That is actually scary and unethical. WE are the ones who ought to have insights about us because WE are the expert on us, not any other human.

Even solution-focused therapy will not work because the 'solution' has to come from clients.

IF you want answers, then a psychiatrist will gladly plonk a label onto you and try to 'fix' you with a diagnosis and/or meds. Or analysts will gladly listen to you and tell you what is 'wrong' with you. But this is not what (good) therapy is supposed to do.

If this is your expectation from therapy, then maybe therapy is not for you.