I also suffered some years ago from undetectable leakage. Then I used a small endoscope to look inside the beam in the bonnet, where the horn is mounted. I found that internally the water was leaking to the interior due to a cracked seal.
To avoid going on a hunt to repair all seals, I treated the bonnet inside with anti corrosion grease, also sprayed this inside the beams.
This stopped the leaking, and also prevents any rust.
The other source of leaking was due to cracked plastic covers on the inside of the doors, so I replaced those covers with home made new ones from PVC, that stopped the leaking from that side.
Now my car is 90% leak free, but in heavy rains, still sometimes some water gets in at an unknown point, So I frequently check the underside of the carpet to see if it is damp, but usually this is fine, and when needed I lift the carpet to let it dry for a few days. This is in my case the maximum achievable result.