Yesterday I really wanted a moonroof because heat rises!
What I did in my Avalon on a hot day was to crack the moonroof with the A/C to vent the cabin. I may crack it at work since I have to park outside. I tilt the moonroof an crack the interior shield to keep rain out. When driving, the lift provided by the tilt creates a slight low pressure system to literally pull out the hot air.
I miss my moonroof!