My understanding is that Security/Quolsys does not support Z-Wave Sensors, but does support other Zwave devices like lights, outlets, etc. Is that correct?
Correct, sensors need to be one of the RF radios on the panel. For instance if you get the 319.5 Mhz IQ Panel 4, it supports both 319.5 Mhz Qolsys and GE sensors and PowerG sensors.
I purchased 2 Yale Assure Z-wave locks for my front and back doors. The plan is to tie them into my Surety Quolsys Panel. After adding the locks to the Panel, is it possible to also add them to my Hubitat Hub, so that I can do home automation from there?
Z-wave devices cannot be independently paired to two separate controllers. The controllers would need to be linked after the locks are added to one controller. The ability to Add/Remove secondary controllers can be unlocked on the panel by enabling Advanced Z-wave Settings in your Z-wave settings menu.
This is found on the panel under Settings > Advanced Settings > installer code > Installation > Devices > Z-wave Devices > Z-wave Settings.
No specific secondary hub is officially compatible or has an official guide from the manufacturer to my knowledge. This would be the only way to control a Z-wave device through both the IQ Panel and a second hub however, and other users have done this with other hubs. A user wrote up a guide on what they did to integrate the panel using Home Assistant.
If successful though you would have remote control/automation in both ADC and your hubitat controller.
Am I correct that in order to have your AI Doorbell Camera ring to a mechanical chime, you will need the Doorbell Camera Power Module ( ADC-VDBA-PM-750), is that correct?
No, the power module for the VDB750 is not always needed, and is used for digital chimes typically.