My dad was almost never grumpy (mind you, he was an alcoholic, and by my mid-teens, he'd almost completely withdrawn from interacting with the family, except on our annual camping trips and at Christmas - but he still wasn't really grumpy...and before his drinking got so bad, he was lots of fun, and a super involved dad.
My ex was...I don't know if I'd say grumpy, exactly. But, he was emotionally abusive, passive-aggressive, and basically just a nightmare to live with. (In addiction to the drug addiction that I sort of knew about at the time - meaning, I knew he had major issues with pot, but he managed to hide the cocaine from me until after the breakup - my ex also turned out to be gay and hadn't admitted it to himself, yet. So, obviously, he had a lot of issues at play, and grumpiness probably wouldn't even have registered on my radar.)
DH is almost a cliche in this area. He's not generally grumpy. But, if we go too long without sex, he's grumpy. He's not "I'm not going to help around here" type grumpy or anything. A lack of sex just has obvious and powerful effects on his mood.