This motivation thing is hard for me as well. I have multiple mental and physical health issues and sensory disability and it is so incredibly hard for me to motivate myself to do anything. Sometimes I honestly think I am just being lazy and trying to justify it for myself but as soon as I actually get up the energy to do it I realize fairly quickly that I really don't have anything in me.

I am always behind on the dishes. Our apartment is, in a word, attrocious, and that's by my standards. I am not happy or comfortable where I live, because of the mess, but I find it so overwhelming that I am doomed before I can start. It doesn't help that I live with someone that literally does not contribute to any housework. So that further saps my motivation.

Some things that do help me:
...i break down jobs. For instance, whenever I do get around to cleaning the kitchen, it's usually several loads of dishes and sandblasting stuff off the counter that's been glued there for however long. My back can't handle being on my feet for hours at a time sometimes so I will maybe go rinse dishes, sit for 5 or 10 minutes, go back and finish getting them into the dishwasher, or only partially load the dishwasher, then another 5-10 min break, then go back, finish loading and run the dishwasher, and start up a sink of soapy water to start washing stuff by hand. I continue like that until it's done. And I do everything that way. Taking out recycling and compost, doing the laundry, cleaning the bathroom - I'll clean the sink and mirror first, then work on the tub and tiles, then the toilet, then the floor. In the bedroom I'll sit on the bed and work through the piles of stuff on the floor because I can do that sitting. And gradually work my way around the room.

It also helps to make a list breaking stuff down, say, by day. Do one important or big chore per day, but allow myself to break it up into manageable bits with breaks in between. Hurting myself and/or overwhelming myself with the workload, no matter how huge it is, doesn't do me or anyone else any favours.