any zipped/archive file, password protected or otherwise has to be unpacked (this would create new files which depending on the file type would be scanned) and any executable file run (again avast intercepts the execution and the file is scanned, if infected avast alerts and doesn’t allow the file to execute). So yes there is every point in an AV.