My sons dad had cancer moon but his Venus was in Aqua. He has a sweet side, very nurturing. He loves to cook and provide for his family, he was the type who would rub my temples when I had a headache, or bring me a heating pad and ibuprofen when I had cramps Lol he’s an amazing father too.
I imagine a cap sun with Pisces Venus as well as cancer moon would be a well balanced earthy but sensitive man. What is your sign? If you’re water/earth he would probably work out well for you.