I am like this OP. I simply don't have good organizational skills. I'm very good at my work, but at home I let my drawers go to rack and ruin. I have done clearouts, I have reorganized things with labels and files, but I forget immediately where they are or where to put the stuff and I find it all a year later. As someone said, though, I may not spend enough time on this. I just don't seem to see how things could be arranged/where things go. I don't have ADHD and manage admin stuff fine, usually by doing direct debits, I do often double-book myself even with a calendar, I actually forget I have a calendar!
I have a friend who is the opposite, her house is a pleasure to visit, they have lists of food when it runs out, chore rota, everything is organized. She also does this as a job. I think it's fantastic but would find this would be a f/t job for me, so choose not to prioritise it.
I work in a demanding job, requiring a lot of thinking/writing, and have just had to accept I can't have the house I want unless I sacrifice a couple of hours of day to cleaning/tidying and I'm not prepared to do that. Have cleaner occasionally instead and keep cupboard doors shut! I also do file important docs (e.g. passports) all in a metal box.
I would work out the priority things to organize and forget the rest.