Roof should NEVER leak even when not sealed tight
For example:
Sometimes mine won't close UP all the way and there will be a tiny gap at the rear and after DOWN POUR= NO LEAKS INSIDE.
WHY? ... because the 92 and after camry's have 1 drain tube on each side that runs down the headliner into the sides of the trunk and out the bottom of the wheel well behind the tire.
The only other way it can leak is if you have the same problem as mine and you park the car on a STEEP DOWNHILL GRADE... then it can't drain back until it levels out or overflows onto your seat
I had a wasp clog mine too except a nice little shot of air FROM THE BOTTOM up through the hose unplugged it.

Make sure if you unplug it that you go up top when the roof is open and remove the plug you just blew up so it wont fall back down and plug it again. remove all other leaves and dirt as this can replug it too.
he he