As a child I was very OCD about keeping everything neat, organized and tidy. My room was like a museum, with everything arranged into collections, lined up, labeled and in alphabetical order. That was me as a 'happy Aspie'. However, as I grew older and began to become more depressed, hopeless and exhausted due to my difficulties, I found it harder and harder to keep things tidy, until I became exactly the opposite. My house is often in total devastation, while I block everything out with my relentless focus on my interest.
I think what happens now is that I don't know how to clean and tidy without it being some mammoth, meticulously organized and carefully executed master-plan that takes days to formulate and days more to carry out. It has to be exacting and so takes a ridiculously long time. I basically have a standard for tidiness that is so high and obsessive that even I can't meet it anymore - and yet I don't know how to do half measures, so it often doesn't get done at all. I also have real trouble knowing what to do first and how to be methodical. I end up feeling compelled to do things like categorizing all my books in a new way, and taking two days to do it, while all my dishes are dirty in the sink, and I have no clean clothes, that kind of thing. I just don't know how people manage to deal with all the different aspects of life at the same time - a job, keeping a home clean and tidy, doing their paperwork, budgeting, shopping...it's endless. I don't get it. It seems impossible to me, like an insoluble calculation.
So, I can totally understand how an Aspie, especially as they get older, can be incredibly tidy 'at heart' and yet their home be in complete chaos.
This is why psychs have to have a lot of experience and insight when assessing people, because the Aspie cliches can often be fully present, but get turned around. In fact, I suspect that, often, the more heavily present and intense they are the more likely they are to get turned around and end up in a strange apparent paradox. One just has to fully understand the dynamics at work to recognize them.