I need u to help especially guys opinion?

Not much left to say that midlifemadness hasn't. He is deeply depressed. It's a mental condition that makes him seem like another person. Some people can't just roll with the punches. Hopefully, he can get back to a sense of stability where he can love again.

What we have here is an example of just how destructive the whole "provider" role that has been foisted on men actually is. This guy thinks he has to be the provider and is some how less of a person even a failure if he doesn't measure up. Men like this have the weight of the world on their shoulders some have even broken under the strain and abandoned their families to escape the slavery this "lifestyle" imposes on them.
The sooner we get rid of this kind of backward thinking and embrace gender equality the better. Their has been far too much suffering from this dehumanizing garbage.

I'm afraid if you were to hang on with him in your lif or waiting for him to come back he will drag you down also. Maybe being away he will discover something and make a real go at life. But if he returns with nothing, it will remain that way and he will be lost and you with him, if you stay with him.

It pains me to no end to inform you of this, but I must cringe and just bear it:

You are in a relationship with a robot.

This is not a joke. Though he lacks the exterior metallic machinery, your love interest has equated his self-esteem with the slavery of "Being Useful". You are just starting to realize this about him, because he no longer feels Useful. This attitude was likely ingrained into him years ago by his parents, who put far too many expectations on him and only gave him their approval (which he equated with love) when he was servile and obedient to them. This robbed him of his ability to function as a living, instinctual, loving organic being on this planet. Even his "love" for you is merely a function, a role that he believes he is expected to play.

Better yet: imagine your relationship as merely being a domino in a series of other dominoes that isn't happening now because the other ones (job, money, home) got derailed from the chain.

I'm not telling you this so that you'll feel bad about him. Rather, it should help you to understand him. The origin of his problems of course did not begin with him. It isn't his fault, but it is his problem. The only way to restore the robot to human form again is through the one path that he feels closed to right now. And this, of course, is love. Love is not functional, not a routine, not a command. Love is alive and instinctual. Present this to him for as long as you feel it is your will to do. It is your love to do with as you wish. But don't expect the robot to understand this. He could return to life again. But until then, you can only love, and maybe your love will turn towards someone else, maybe it will forever be with him. Whatever you do: don't buy his sh1t about jobs/money/future. What does love know about these things? Merely do your part: love and let the robot work his sh1t out.

If your love doesn't do it for him, he will never do for you.