Remove the passenger side windshield cowl. Don't forget the screw that is under the little black tab in the middle of the cowl. No need to remove the drivers side cowl.
The water is getting in through your "cabin air filter" on the passenger side of the car. The actual paper filter may or may not be there. You can clearly see how water rolling down the windshield will get into the filter. This is why it has to be sealed. The drivers side cowl is actually not sealed at all.
Clean the cowl where the previous sealant was. Also clean the windshield.
Put a strip of the new butyl tape or some sealant on the cowl (not on the windshield) and make sure it seats.
Put the cowl back on and press on the butyl tape to get it sealed.
You know you’re into cars too much when your girlfriend comes over to show you how she died her hair and you say “you should have left it stock”