Hi Detox - there seem to be a lot of men like this around. I think you have to realise that you can't change his behaviour but you can change yours in the relationship dynamic.
What I mean is that our lives are a bit like a play with a script and each partner knows their part and plays it out. We may not always be conscious of this but it is a fact. Your dh knows that he can get away with being a stroppy, and he will also know you are always checking to see what his mood is. Again he may not know this at a conscious level but he will at some deeper subconscious level. We are all like this.
A can only behave like he does because B lets him, and if you do what you've always done you will get what you've always got.
SO - if you are up for testing out what I am saying, just make one very small change - I don;t know your script but you do. You may have to act the part as it will be hard for you to change the way you have always been.
I was a sw for 30 years and worked with a woman in your position. She said that if he lost something he went up the wall, moving all the furniture and generally making everyone uncomfortable. I asked what she did and she said she got anxious and started helping to look, with him getting more and more shouty etc. I advised her not to do anything the next time it happened, just sit with a book (she used a gardening book with a note inside saying "Don't do anything) she was too anxious to read the book.
We had a good laugh the next time this happened because she said he was completely nonplussed about why she wasn't playing her usual part and kept saying to her "I've lost xxx and don't know where it is" and she replied "Hmm and held on to the gardening book, while he got more and more shouty. Eventually he challenged her about why she was reading instead of helping him and she said "you can look on your own, I'm not stopping you" (she said took a lot of courage) but she said the most telling thing was his confusion when she didn't play her part. She said he stood in the middle of the room looking like a "little boy lost" - not sure how things worked out because I had to close the case.
Sorry this is so long but thought it might be worth a try - just one small thing to begin with - may make things worse not better but would help you to see how the dynamic of our r/ships get set in stone and sometimes the concrete has to be dug up!