Water in the driver side footwell may have to do with a clogged drain. I am not sure if it is from the sunroof, but there is a drain that when it gets clogged with debris it leaks into the drivers footwell. I have read about this issue in several forums.
The door locking and lights flashing may be associated. Check the battery. Mine was doing some wonky things as you descibed. I replaced the batteries in my remotes and the battery in the car. I haven't had any issue since. I did notice that my passenger front door lock would stay up when the other locks engaged. Immediately the rest of the locks would reset. When I was replacing my door handle gaskets (thanks Shogun) I shot a dose of teflon spray liberally around the lock mechanism. I couldn't guess to say which repair did the trick.