I just had 2 inches of water in the front passenger area from a clogged front drain. Bottom elbows were in great shape but the drain hole was blocked at the top. Pretty easy fix with my weapon of choice that I found - Cat 5 cable. LOL.

I want to check the rears. It looks like I'd have to remove the sunroof to get to those if I want to go from the top.

 

Don't go from the top, its much easier to remove the trim and go in from below, you don't even need to fully remove it, just bend it out of the way enough to get your hands in.