So I'm still looking for the leak, but having no hose in the apt driveway makes it almost impossible. I soaked up the pool of water in the cubbyhole and painted all the rust. You can tell the level of water by how far up I had to paint.
I looked for leaks near the side window, but couldn't find any. When I first looked into the bottom of the cubbyhole, there was about 1/2" of really fine sand. It seems like where the water runs, there's a trace of sand left behind. I looked into the pillar by the hatch on the passenger side, but it's super clean in there.
I also looked under the passenger side rear window, stuck my head into the cubbyhole and looked up to see that pinch seam, but it's also spotless there. No dust, dirt, or water marks there.
The only thing I could think of is that water is going behind the passenger side light assembly, and getting into the cubbyhole through the rubber plug that the bottom of the light housing snaps into. There's a layer of fine sand all over the back of the light housing, so I know water is going there. I pulled the plug and sealed all around it. I also sealed every pinch seam around the area.
I'm sitting here looking at the pics I took and notice some sand stains near the rear hatch floor. Maybe there is a leak on my rear window. Guess I need to pull the plastic there and see.