Not helpful for the majority of the people but I just forget to close the sunroof and it self regulates, only downside is I did have a spider fall on me before.
With the torrential downfall here yesterday afternoon, you would have had more than a spider fall on you.
We had it as well, rain doesn't get in when it's just lifted and drained lines are clean. A option for the majority would probably be wind deflectors and leaving the window open crack in the heat.
