Both Cancer and Scorpio are going to be cranky, loving, caring and even sexually severe