In any case, getting a job in a place where you'd be happy should "restart" your life: job is also a means to a new social life where you make the break from the old. So it sounds like you are only a decent job away from starting on the right path.
Having some vices also allows you to connect with others, so perhaps pick up a few non-damaging ones :D
Finally, note that you should look for professional help instead of listening to any of the advice I might give, though finding a psychologist who you can connect to is sometimes an ordeal as well.
And regardless, do consider adoption, even as a single parent. There are loads of kids taken away from parents who for whatever reason can't really care for them. Often there's a generational component: the kid's grandparent abused or couldn't support the parent; the parent ended up in foster care, exited out of the system at 18 with no support network, got pregnant, and can't really support the child. If they're not placed with an adoptive family, they spend the rest of their lives in foster care and repeat the cycle. You can make a world of difference.
My first marriage took a long time to resolve itself; by the time I married again, and we figured out that we were having fertility problems, my wife was "over the cliff" fertility-wise. We adopted a little one and he's been a real joy. You are wired to connect with children, and children are wired to connect with you; those circuits in your brain can't read DNA.
Obviously you need to get your own life sorted out first: lack of work and depression feeding into each other are major contributing factors to the problems the kids' biological parents have taking care of them. But get your head in the right space, a good support network around you, and a steady income, and there's no reason you can't be welcome a child into your family. Obviously having a partner can make the burden easier, but there were plenty of single-parent adopters in the "cohort" going through the adoption process with us. It's definitely do-able.
OP - You are young! Not even 1/2 way through life. You can do it.
I am struggling to think of any official agency which would pair a child with a single man. Is this really something that happens?
Tons of other good advices here - if you think you really are suicidal (and not just fleeting emotion in the lowest position), get professional help, even if it means moving away. You owe to yourself as much as to anybody else, including your closest family. Otherwise try to get a job you want and like, AND get into some sports, whatever it is. Being active brutally increases mood, happiness and often integrates you with like-minded people. On top of usual stuff like better sleep, sex, longer better life overall etc.
Do some 'charity' work, helping unknown people with whatever, its extremely rewarding. Attempt in some way to overcome procrastination, attack it from different angles, ie set up appointments that you would feel ashamed to cancel later.
Finding a partner becomes hard, especially if you expect her to be 5-10 years younger.
I used to be rather successful with women, was never single, always could find someone easily. I'm 45, in good shape with a good job, but it has became much harder.
The good news for GP is I think for a lot of people what you consider to be much harder is just the norm.
Same goes for OP. I'm literally his age, don't own property, have less in savings (I don't work in tech), and consider myself both lucky and free. Also lucky not to live in the US, where other people's perceptions of your relative wealth seems much more important for dating / social life etc.
Perspective governs so much of how meaningful and rich our lives seem. I look at my family / contemporaries who have children, or have crushed themselves at a desk for twenty years and feel inestimable gratitude I didn't sacrifice my life on that alter. OP's problem is a long period unemployment and depression, not some kind of nebulous 'failure'. Fortunately it's readily fixable. 43 is not remotely 'past it'.
But in any case, I think it's not that different as wanting a wife and kids. You need to be able to seduce someone, whether it's for a casual relationship, or for marriage. It's start with physical attraction either way. I don't think mentioning "I want to get married and have kids" will give you a free pass which is ironic considering many women complain men only want casual relationships.
Modern dating where people meet online makes it harder too. A gay friend of mine who is 60 years old says that back in the day, he would meet guys in saunas or bars, and older guy would have a chance. But online, nobody want to meet a 60 years old guy.
You're also most likely much more selective. In your 20's and 30's, there's no feeling of a clock ticking.
I guess my point is prioritize fundamental character (honesty, communication, loyalty, values, etc), and someone you can have fun with. The rest can be taken care of with time and effort.
I think solving your personal issues and the job should come first.
I wish people would avoid not rejecting "it's too late for kids at 43".
The more implicit affirmation you hear on HN it strengthens that false belief.
So, you're saying: you wish people accept its ok to have kids at 43?