I ... don't really ever feel this way. Maybe if I'm very sick with a stomachache, but that's pretty rare.
I've got a nonsensically high sex drive, both mentally and physically*. My partner's complained a few times that I'll have hurt my arm or leg or something at work, and I won't tell him til *after* we've had sex for the night. "You should have told me! I need to know these things so I don't hurt you!" "Honey, if I told you, you'd try to be all gallant and we wouldn't get to have sex!" and then he just sort of frownsmiles, because he knows I'm right
*I recently (3 months ago?) started a course of antidepressants, and it's been really interesting because while my physical libido is slowed a little bit, the mental component is just as strong as ever. So when I'm not around my partner, I masturbate ~ every two days instead of twice/day, but I still think about sex a lot, and when I'm with my partner I still warm up whenever we get started. The 'warm up' is kind of new, though---I used to be always ready and rarin' at the drop of a hat, but now sometimes I have a little of that 'sigh' that you mentioned beforehand. But let me get a good look at him (and maybe a good tweak or two on my nipples) and I forget about the "hassle" that made me sigh.