Don't feel guilty at all. Most of us are that way at times. As wives & mothers we are always taking care of others and we want scheduled and unscheduled "me" time sometimes. Men get their me time with friends, TV, football or sports, fishing with buddies, golfing with buddies, alone time in the garage or workshop, etc. Everything we do is either for or with our spouse or family.
When hubby comes home DO NOT tell him or indicate how much you enjoyed having him away. DO tell him (little white lie) how much you missed him.
Good marriages sometimes include hearing from our spouse what we want to hear, even though we know they are just saying it to make us feel better, i.e., (husband to wife) "Honey, that was a great supper" (even when you know you burned the pot roast and it was almost too dry to eat). Within reason there is nothing wrong with telling our spouse what they want to hear just to make them feel better. This is what you do when hubby gets home. You can also fix his favorite food when he gets home - it doesn't have to be a romantic candelight dinner.
As far as a pat on the rear when you walk by or oogling you when you get out of the shower, dressed, etc., this is a hard one because like you said, you're glad he still has the hots for you, it's just that his timing is way off and he doesn't know it. If you tell him how much it irritates you he will misinterpret it and feel rejected. I'm very irritated that my hubby follows me into the bathroom whenever I have to pee. He's like the kids sometimes, who think that when I'm on the toilet they have a captive audience and I can't escape. :) He wants to visit with me but I just want some privacy and a few minutes alone. Just as soon as I shut the water off in the shower he has been listening & waiting and pops in to oogle when I step out. This happens when I'm running late for an appt., trying to get myself & kids ready to catch the school bus after showering, etc., always when I'm not in the mood.
These are the things that we thoroughly enjoyed when we first fell in love, had no children, no responsibilities, schedules, etc. Now that we do and he doesn't have the responsibilities we do, he doesn't see it or understand it. Basically, we've changed but he hasn't. That's not really his fault or yours.
By the way, I'm 63 yrs. old and married 42 yrs., so I understand & agree with you, but still don't have all the answers. :)