Is there a connector available that can download a zip from the open web (https) and load the CSV contained within to a destination?

The File Connector works for some types of compressed files, but only works for .bz2 and .gz files

I'm assuming there isn't a current connector for .zips (archive files rather than compressed file type).

You’re correct