Here's to hoping that he comes to your bedroom and stays with you while the folks are there. I think this would be a good time to reconnect physically. However, I think I would go for affection without the sex. Maybe give him neck rubs, foot rubs, etc but don't but pressure on for sex and see if that gets him curious.
My guy is an Physical touch guy so I can fill his love tanks very rapidly with just neck rubs (and other things ). Although he was always HD the older he gets the less he is and I think this worries him. So, I go more for just affection unless he takes it farther (and I'm more than happy to cooperate!)
As for going somewhere other than out to eat. Why don't you see a movie while he's gone and then tell him you would like to see it again with him? My guy (the workaholic) never does anything unless I "drag" him there. Then he tells me over and over again that he had a good time. He would never do it on his own.