This sounds really Buddhisty to me, are you implying goals are a bad thing? Just curious, I know in Buddhism stuff like ambition, goals, passion, self-esteem, etc are considered bad things...

I don't think OP has any mental health problems, he probably just needs to get back on the grind. It's like with a lot of top athletes, they'll tell you if they're not training for the big tournament/cup/fight/etc they feel like they're worthless & wasting away. I feel the exact same way when I have no project to work on, so the solution is to stay on the grind.

I think OP is currently experiencing the remote worker's version of writer's block. It's temporary. Important thing is to keep exposing yourself to new things to find something new you spark with.