I have ADHD, and getting diagnosed and accepting that I find keeping the house clean and tidy and setting up strategies to help me was a huge step. My house isn't tidy like a naturally tidy person's yet, but it's so much better than it used to be.
Things that helped were:
Putting more responsibility on other people
I had been a SAHM and when I went back to work, the division of labour didn't get rearranged, so I was struggling with too much to do. We now have a housework list based on the organised mum method and a quick meeting each week to look at what's coming up in the week/month ahead and to divide up our time fairly.
Learning to clean and tidy
I subscribe to the organised mum method and get audio guides that talk me through each task, which keeps me focused and teaches me what to do. I also try to arrange things by ease of use, especially if I'm trying to form a new habit - I currently have some silver that needs polishing on the kitchen windowsill with the polish next to it so that I do a bit little and often. Once it no longer feels like an insurmountable task, they will be able to go back into the cupboards.
Decluttering.
I have a small house with too many people, and this year I took a week off work in the spring to declutter downstairs, and a week in the summer for upstairs. By the end, everything either had a place, or a plan for a place with a task list to work through. So I need to buy some more storage, to find a buyer for an unwanted piece of furniture etc, but I deal with one of those longer term tasks every week, so they aren't just getting forgotten.
Doing a daily and weekly reset and making that sense of clean house feel like a treat.
Every evening, we make the house nice and cosy, use nicely scented products, have candles/soft lighting/nice music/make the bed etc and then I can sit down with a relaxing drink and actually enjoy the atmosphere and do something fun. On Thursday night/Friday morning, I make sure the house is really nice to come to for the weekend, and I buy myself flowers. I spend more on cleaning products that make cleaning feel like a sensory pleasure.
Have nice things to listen to while doing housework.
A good playlist, a gripping audiobook or podcast, or being talked through a task by Gemma on the organised mum tomm rocks app. If I am doing housework with headphones on, I'm doing non-interruptible work, so DH is default parent, making a sandwich/cup of tea/watching TV or whatever people want to do in the room can wait half an hour until I've finished, and if you need my time and company, you join in with the cleaning. This is probably more of a hard and fast rule if you have ADHD and are very distractible.