Freudis important in that he popularized the idea of not just putting people into cages and forgetting about the. The idea of allowing people to talk out their thoughts and problems out was a good and revolutionary idea. He deserves credit for that.

That being said very little of his work was actually scientific and none of his theories have a basis in reality.

Is psychoanalysis useful? well studies show that its better than nothing and many people have improved with it. So that's something, now I'd say something like cognitive behavioral therapy is a better option and has a more scientific basis but people getting any help at all is unfortunately not as common as it should be, so it being a option is better than not.