The problem is not therapy but you landed with an unethical and incompetent therapist. And stayed with them.

She was not 'dispelling any illusions', she was invalidating you.

What kind of therapist tells clients the following:
- I won't talk about this
- most girls will never like me because of my short height, so I'd need to find a miniature girl
- So my therapist told me to stop seeing this girl and accept the fact that I’ll never have a family of my own
- She advised me to start dating a chatbot
- Lastly, she said that science is impotent
- She told me that I need to accept that I have no friends, that people I like don't give a damn about me

This is unacceptable.

I am surprised you stayed with her for THREE years. If you give therapy another chance, please set some boundaries so you are treated with respect.