I too have always liked the cuddling. And it usually does get me aroused. And then I continue on with sex. My W however, would always say roll over and let me snuggle you. That was nice, but I didn't get aroused.
If I get aroused, I'm ready to continue.......
In the past year or so of the marriage, she didn't ever want to snuggle. It was like "if he doesn't give me what I want, I'll be damned if I'm going to give him what he wants." She even started putting pillows in the middle of the bed.