I just read through your original post and the rest of the posts on this thread, and your description confirms 100% that you will find that the plastic ball cups have broken off or popped off their respective steel balls.
The canvas portion of the top will still operate with only one plastic ball cup attached, but the top will lurch forward or trail behind, depending on the particular part of the cycle that the top is in.
In your case, since nothing is happening with the canvas portion at all, both of your plastic ball cups are suspect.
Also, because you must have operated the top with the button at least once (as you explained), that is also the cause of the water intrusion into the cabin, where it ended up under your driver's seat.
Finallly, because you have the "B Version" transmissions (2000 and later 986's), the double relay gets its signal from the inside of the driver's side ("Stehle" brand) transmission and thus does not depend on the earlier version's B-Pillar microswitch, thereby allowing the top to go through its entire cycle, even to the point of turning off the idiot light on the dashboard.
Here is a photo of where you should be looking for the plastic ball cups, in this photo with the canvas top halfway up and the rear main bow in the 45 degree position. They will be either red or, more likely, in your case, white plastic. Do not remove any remnants of either plastic ball cup from the front metal pushrods onto which they are screwed until you mark where the base of the plastic meets the pushrod threads (with nail polish or masking tape). That will save you time and aggravation of having to re-adjust the overall length of the pushrods once you replace the plastic ball cups or the entire pushrod.
Here is another photo, with the red oval showing the area to check for tears of the foam liner.
The Permatex Black Silicone Adhesive Sealant is available at Pep Boys, Autozone, etc., and it's part number 16BR. Works great for this application. If you find that your tears are very large, you can back up the foam drain material with duct tape and then seal it with the Permatex.
When you get the new plastic ball cups (or the pushrods), I can walk you or your brother through the installation.
If you are even the least bit mechanically inclined, or have a friend who is willing to help you, we can fix this for under $50, including the Permatex Sealant.
Regards, Maurice.