Interesting that you should say that. I also find my H to be much happier and more personable when we are having sex on a regular basis than when we aren't. I am likewise familiar with this dynamic in myself. In myself it is more like a nagging unhappiness that I can't shake when we aren't intimate.
For another perspective I just read a book called "Peace Between the Sheets" that recommends lovemaking with no orgasm because biology says that after lovemaking people (especially men) are no longer biologically motivated to "be nice" and that people tend to have a lot of post coital arguments. There is a long drawn out explanation of this in the book. I couldn't get into the philosphy but it was interesting.