Yes, I suggested the doors first since you said the majority of the water is in the back floor board.
The kick panel is held on with one Philips head screw a the bottom behind a removable plug. It then pops loose. While you are at it, remove the cover under the steering wheel (held on by 4 T25 torx screws, 2 on side and 1 on each side of steering wheel). The place your garden hose on the windshield and let the water run down for a few minutes. Then you can verify if there is a leak from the sun-roof drain inside (doubt it from what you have said), the hood release grommet (good catch WeLikeBlue), or the battery drain area clogged.
After you remove the 2 trim pieces and before you run the water, run your hand behind the top edge of the carpet where it ends from the fuse box area to the gas pedal to see if the insulation is wet. If behind the fuse panel is wet, then the hood grommet is suspect, if towards the pedals, the battery drains are clogged.
Just curious, does your car still have the automatic transmission?
Really appreciate all the responses..
Tested 1 & 2.. Put running hose on roof and let it run down from roof onto driver side front and back windows. Saw no noticeable leakage. Were you envisioning pulling back the carpet or removing panels in order to accurately verify leaking or just feel/look for obvious signs of leaking?
3. Cutoff driver's side sunroof drain tip with box cutter and nothing came out. Used tip of box cutter to open up the hole at the end to a greater degree. As a matter of interest, I ran a water test directly on the sunroof and found water draining pretty freely out of the passenger door sunroof drain (which I also clipped previously). However, I saw no water coming out of driver's side sunroof drain.
4. Is testing the left sunroof drain connection behind a-pillar kick panel just a matter of taking panel off and examining connection?
5. Battery Removal and drain check next on my list.. Probably tomorrow..
6. With respect to the rubber grommet for the hood release cable did you find that it was totally dislodged after you took the plastic cover off and looked? Was just wondering if you found it to be loose/not seated well or totally disconnected.