How patient should I be with a Cancer Man?

Hello fellow Aries! I'm brand new here and am just gonna dive right in, head first. I need some sound advice on how to proceed with a Cancer man. I have read a lot here and although I have seen some wonderful advice, it is not specific to my sitch. Here is the short and tall of it all:

We both work at a bar that his mother owns. I have been there as an employee for a year, but have been a patron for a decade. I have known Cancer Man the whole time and we struck up a deeper friendship around August. I'm crushing the whole time but had absolutely NO CLUE as to his feelings because he kept that under wraps forever. So we build a friendship, hang out a lot and also we work together very well. Things are nice and fine like that until early January when we were hanging out and head back to his place like we have done a million times before. Having had too much to drink to drive, I asked to crash, which I have also done before, but always on the couch. This night however, I was fueled with liquid courage and asked to sleep in his bed and then whoa! Did we ever burn a fire there! This man who never let it be known once that he was into me, knocked it out like Casanova on an Oyster binge. A very comfortable, confident, passionate lover that leaves me yearning. A real dream for me. The next couple weeks have been hot and cold though. I researched Cancer men and he seems to be the one they wrote the book about: Moody, Mama's Boy, Never Direct, Sensitive, Artistic, etc...So I am being patient and aware with these qualities. When I adore someone, I tend to dive in. I am not afraid of my feelings nor do I have any problems expressing them. I have put in a ton of effort and I don't feel like it is being returned. That's fine, I can pull back. But in your experience with Cancer Men, do they adore the effort and just aren't good at expressing their feelings about it? I can be selfless and keep giving all day, as long as it is for a good person. I believe he is a wonderful man who is wary to trust people. Or should I just pull back completely and say, "Hey Crab! I want effort or I'm out!" It seems the only time I am confident in his adoration is when our clothes are piled on the floor. And I do not mean for that to sound cheap. Sexual connection is very important to me. How patient should I be? It's only been one month, by the by.

I hope my sentiment comes across here. It's hard to cram a giant emotion into 2500 words or less!

I would like to add this:

The Good- SEXY, We share laughter, He told his mother about us and she was stoked, He gets along with my 6 year old son, He calls often, he cancelled moving out of state but then...

The womp-womp- He changed his mind about moving out of state...again, He never makes the first move, Hardly compliments me, Leaves me confused.

I hardly got compliments from my cancer too he says its because he doesnt like to gas or compliment people whom he feels already receives a ton of attention. But yes they are hot and cold but from my experience it wasnt because he wasnt interested in me but he wasnt interested or ready for I represented. He had just come off a 10 year relationship with his childs mother and it ended really badly. so he was in his shell when I met him (emotionally at least). He is moody and def a momma's boy and sensitive but also extremely honest which is something im not used to with men. I think if you really talk to him, you may get an answer and find out why hes behaving wierd. Also it could just be that thing that men do after sex. They get distant and we cling. And in that case Id be more patient because he could be testing to see what your reaction may be. Wait it out and act unaffected for a while and see if he starts to go back to normal.

As if he were a mind reader, he called tonight to acknowledge my effort and expressed his disdain for himself for not being recipricol. I told him that I didn't ask for much and had no agenda regarding us and that he could trust me. He proceeded to go on about how he would make a terrible boyfriend because he has other priorities besides us, I could tell he was a little sauced but think that he may have been trying to tell me something. He then 180-ed and went on to say how I awesome I was and that he was depressed about moving. He is obviously confused and...what's the word?
Oh yes, Cancer. Ha!
I said I just wanted to enjoy our time, simple as that. but don't tell me that you have other priorities besides me because I refuse to be unimportant or second fiddle! Sheesh. Thanks for the advice, lovelies, only time will tell at this point!