A few thoughts here, check rear drains too, if you were aprked on a slight nose-down incline water could migrate to the front. Don't poke too hard, take your time, if they are clogged you risk pushing the tube off the nipple and then you would need to disassemble the headliner to reattach.
Since you;re in SoCal it's possible the sunroof seal is dried up. Use Shin-Etzu to re-lubricate and moisturize the seals. Avoid getting any in the sun-shade slider rails or it won't open smoothly anymore. AT-205 brushed on the rubber would also physically swell them up a bit. You can check our signature link to find either product on Amazon.
For windshield sealing if you think it's a minor leak, you can buy Flowable Silicone at auto parts stores which is very thin and when you apply it, using something like the syringe offered above, and it will then flow into various crevices that normal, thicker silicone would not.