A lot of pps are making out as if the DH in the OP isn't having any sex with his wife and snapped in frustration, when her OP indicates it's been increasing lately and they've been working on being intimate.
I get that it can hurt to be continuously rejected, but that isn't what the OP described, and even it were, is him initiating sex at midnight and then snapping that you won't love them and will cheat unless they fuck you more often an appropriate way to start an honest and respectful discussion?
We've had our dry spells, and if dh decided he's going to celibate (which is what a few pps seem to think the OP is doing for some reason) then of course I'd want to talk about it, I'd be hurt, but I wouldn't raise the subject by trying to shag him at midnight when he's going to be up early and then start a row and tell him I'm going elsewhere for it and that I won't love him. It sounds like OP doesn't get much sleep as it is, can't imagine she got much after he dropped that bombshell.
its also odd that so many people are saying that he wants affection (in his case sex) and has snapped that he's not getting it and making suggestions on how she can fix it, whereas OP has said she also wants affection (in her case hugs etc) and he's not giving her it. Where's the critisicm for him at failing to meet And ignoring her needs?
If Op had said she wanted to Kay in bed hugging and chatting but said he was tired so rolled over and snapped and told that his lack of affection is killing her love for him and she will cheat if he doesn't do what she wants, she'd be flamed.