|Perl: the Markov chain saw|
Keep an eye on https://www.theregister.co.uk/2020/05/07/worldwide_job_vacancies_for_you/ and its weekly equivalents. During lockdown, they are offering this as a free service and some of the jobs allow 100% telecommuting.
I doubt whether you are a bad programmer or you wouldn't have survived this long. I strongly suspect you are bad at your current job because you are not enjoying it and the two usually go together. Look for things you enjoy and see whether it is appropriate to turn them into a career. Be careful, because the corporate graveyard is full of restaurants that were started because someone enjoys cooking on a small scale but couldn't make the commercial grade. Computer related areas you might consider are:
Others have made the point about private projects. I think it's important to get your enthusiasm for something back. And the advice you get here may not be the best. Try getting on to a professional recruitment firm and asking what they recommend.
Update: I have tried several times to approve the OP, but I suspect that there is something I or the system can't understand.
Update 2: Fixed minor typo. Thanks, soonix. And another, quoted in the follow-up.
Update 3: As usual, xkcd is on the mark: https://xkcd.com/1768/