It must be weird to have Moon in Leo as well.
I'm a lunar Leo, and I think it's a great placement. As a mature woman with a night birth, my Leo moon would be stronger than my Aquarian sun, by some point-tallies. Since the moon rules one's feelings, it helps to feel "sunny," generous, playful, and so on.
But everyone needs to feed their moon. The moon rules one's home, so having a home that gets a lot of daylight is good for a lunar Leo. Even better, in a desert climate, as Leo rules deserts. In winter, light candles or put a fire in the fireplace, if you have one.
Pisces moon? Maybe this person can keep a home aquarium/fish tank, and live by the ocean.
It occurs to me that an unhappy important sign, whether it's the ascendant, sun-sign, or another planet's abode, is being starved for something.
With the ascendant as how we present ourselves to the world and come across to others, a starved Capricorn rising probably feels best being practical (earth) and setting achievable goals. The big goals need to be first broken down into small steps, so that the feeling of achievement is achievable.
One thing that affects any rising sign is the situation of the planet that rules it. To paraphrase Demetra George, the house and/or sign ruler (she uses whole signs) wants to help out the affairs of its house, but whether it can do so brilliantly or poorly depends upon its own situation.
So, for example, suppose Capricorn (or Aquarius) rising are ruled by Saturn conjunct Mercury. One reading would be "pessimistic thinking." Where as Sagittarius (or Pisces) rising are ruled (co-ruled) by Jupiter. Jupiter conjunct Mercury might mean "optimistic thinking."
So the rising sign itself is just a first step.
Further, the ascendant ruler or the sun in the 12th might indicate someone who prefers to work behind the scenes. If s/he's thrust into public speaking on the job, this person might beat herself up for making a hash of it, especially if the ascendant ruler is afflicted.