Hey chrome I'm not BlackFoot but let me see if I can help in anyway. I do have a couple of questions.
Did you want to cuddle or were you trying to cuddle your way into her pants?
If by "mystery" you mean a guy with game & in the guy with the stupid hat I think you should really look at the Seduction stuff that is out there and ask you self if you want to put on an act and be loved for that or do you want to be free to reveal yourself and be loved for that. There is some good information out there but allot of it is just a joke.
For the purpose of brevity I'll just assume that you wanted both really. As a nice guy you may have to go out of your way to ask for exactly what you want directly and uncensored. Not because your going to get the outcome you want but to present and reveal yourself.
In the situation you've posted seems to me you're talking about two things cuddling a need for affection with non sexual intimacy and sex. If your really wanting sex in the scenario you never actually were rejected for it if she's just turning down your invitations for a "cuddle".
Do you think your wife may have stayed up late to avoid the "cuddle" that you were waiting for? Could you see her doing this if the invitation to "cuddle" was loaded.
Anyway I've made a big assumption here and could be totally wrong so I'll stop writing.