Thanks for the photos! I am now dealign with this. What did you use to clean out all the water intrusion on the harness plugs?My thanks to this incredible forum! The foglights on my 2008 mysteriously came on this week and drained the battery. I was bracing myself for a potentially long and expensive process of trial and error. But the info in this forum helped me get to the root cause right away. A clogged sunroof drain caused water to be diverted down the driver's side A pillar and caused corrosion in some of the electrical junction boxes. Note the blue goo in the pictures below. Everything is fixed now.
I hope these photos help somebody else down the line.
I dried it all up, vacuumed it all, wiped it down and unclogged my drains. Works as it should but a few hours later my alarm kept getting triggered. I am thinking there is another plug still wet somewhere so I have to unplug more things, dry and clean them.