My DH has ADHD, and I can recognise some things in your post that happen in our home.
With us, it's more communication that struggles, because he's very black and white and quite over assertive in his statements.
However, today for example, we got little sleep over the last few nights, (young twins being buggers) and this doesn't affect him, where as I am like a zombie. I fell asleep from exhaustion on the sofa, and he took them outside to play in the garden and then made their tea, so I could have a power nap.
Counselling doesn't work too well with ADHD I think, as certainly with DH his brain works one way and one way only, and no amount of talking or reasoning could genuinely make him see another side. He might pay lip service as if he agreed, but it would be pointless as internally, he would be thinking it was all a load of rubbish.
With your DH, the ADHD is definitely the cause of his constant distraction, but he's not blind. He can see the mess in the house, he can see what needs to be done. With mine, we use lists. If I say "clean the house" he gets overwhelmed on where to start, what order to do things in etc. If I say, "clean the shower screen with viakal and this cloth" then after, say "clean the sink and loo with this product" then he'll fly through it.
Breaking things down into manageable chunks gets things done here. Similarly DS has ADHD, and if I told him "revise for 2 hours" he wouldn't know where to start, would get overwhelmed, then distracted. So I say "work through questions 1 to 7 on this page, then come and show me" then when he does, I show him the next part to do. Yes it's frustrating, and micro managing, but it works.