I'm sorry you feel this way.
I can relate as your description fits me pretty much perfectly. Not on most days anymore luckily but on enough of them still since my uni graduation 4/5 years ago that I ended up as a 36 year old without any career, job prospects, self-esteem or urge to be productive (outside of house chores and child care) to speak of. If my wife hadn't support me financially these past years while I travelled with her to the different places where she worked and eventually allowed me to father her child and become a (often still feeling worthless) stay-at-home dad, I don't know how I would have ended up. Quite possibly even worse, unless it would have forced me to take my life by the reigns again.
I can only imagine how Spoony must feel when he can never fully hide from view and take some time to recouperate and work on being happy and nice to himself and those around him.
You take care Patrick S. Try to find something positive in your life, even if it is something small or seemingly insignificant, and try to build other positive things on top of that. Having more people in life to talk to on a deeper level and relate to can help immensely as well, as I've discovered myself. As long as you don't fall into the trap of comparing yourself to them too much and feeling like you've fallen behind in life as a result (like I still often do, even to my wife I admit). Life is not a race between those that made it and as such matter, and those that are stuck at zero and are worthless, despite how strongly we get this impression (from media). You matter and have worth, even if you don't feel like you do.