I recorded a video yesterday but haven't posted it, yet.
We have owned this car for 11 years and and my wife hasn't noticed a problem with rain water until last year. I am thinking that a seal finally cracked.
After taking out the wheelwell, yesterday, I am starting to think that this car was in an accident prior to us owning it.
Hint of an accident #1. I noticed that there wasn't any sound deadening foam in the fender. That is usually standard from the factory. The passenger side has it.
Hint #2: After referring to ford's crowl parts, it seems like it is missing a couple of parts. However, it doesn't list a hose in the schematic. Perhaps, it is part of the fender piece, which is the one on the bottom right in the pic below.
It is likely that the person that fixed it didn't bother to replace the hose or the other 2 missing parts.
Going to go up to a local ford dealership to talk to them about ordering these parts for me. They might share some insight on the hose.