This is a sign I am rather familiar with since I have a birthday today. I'm also blessed or cursed with 6 planets in Sun, Moon, Mercury, Mars, Venus and Pluto (only a planet astrologically) I also have a series featuring Cancer heroines - Moon Child. At this point there are three completed and I'm working on the fourth one.
The character with a Cancer sun is usually quiet and reserved yet they do like the spotlight. They are versatile, and changeable. They set their own course in life and have no desire to change what they want to do. They have a fertile imagination and dramatic ability. Tears can flow with ease though they hate to show this weakness to others. They love strange experiences and enjoy the occult. They may be psychic and have a retentive memory. They fear ridicule and love kindness. If someone badly hurts them, they will remember and they will erode this person rather than blast.
With a Rising sign in Cancer, the character will be changeable about life and their occupations, enjoying more than one but usually one at a time. They have a tenacious memory. They are industrious and frugal. Fear of ridicule makes them discreet and conventional. Their emotions are strong. They are receptive to new ideas. They have a knack for adapting to their environment.
Moon in Cancer. The emotional nature. There is a desire to work along the line of least resistance. They are sociable and domestic, sometimes talkative. Their emotions are influenced by the environment. They can be imposed upon and may resent this but never complain. They enjoy travel and home. They are fond of the occult and antiques. They desire to live near water. They may be either consciously or unconsciously psychic.