You are not useless you are overwhelmed.
I have dyslexia diagnosed since I was a child and a few other bits suspected but I'm not going to follow up those.
I need to be organised. I can see it now when I was depressed/ very overwhelmed the house turned into a state.
It takes a while but if you can get it all organised so that it is very easy to 'reset' rooms it will make life easier.
In the living room, I have a large box where the toys live. At the end of they day they are all thrown in there = Clean living room to relax
Dishwasher, I used to only use it once a day but now I turn it on twice if needed. I know it's better to handwash some things but everything goes in there. It is emptied 1st thing in the morning so all new dirty dishes can go in there and keep the kitchen clear
Laundry, sounds like a PITA but do a load every time there is a full load. Use colour catchers I try to separate whites but throw everything else in. I get up, I put the wash on. I hang it out. Fold that evening on the couch.
Food, sounds like work but do a food/meal plan. I do my online shop on a Monday and decide what we will eat for the week and but the stuff I need to do that. Takes the all day thinking 'what to cook' away. Also a few things in the freezer helps.
If you can afford it I bought a robot vaccum on the prime day it's actually brilliant.
Keep a cloth beside the bathroom sink and give the sink/ counter a quick wipe as you go.
Extra storage for kids rooms. Kallax from Ikea is great.
Clutter for me is evil. It clutters my whole brain, I get overwhelmed and do nothing. I still have things from my home place that I need to sort out but they live in a big boxes and I will get to them. Because when I start doing that I get very much so distracted and hours can pass.
I listen to an audiobook when cleaning. You and DH could get a lot done in 30 mins together.
I found realising it doesn't need to be perfect helped. I could get side tracked and spend 2 hours scrubbing the window frames or some stupid crap like that.
Also keeping focuses, I still go off on tangents but if you are cleaning the kitchen try and stay focused on that 1 area. Then move on. Give yourself mini goals.