I'm surprised nobody has released a reasonable quality USB camera that supports standard lens mounts. There are some out there but they seem to be suited more for computer vision projects than video conferencing.
Canon at least released a couple "Webcam Accessories Starter Kits" that include a little tripod and an AC adapter to work around the USB charging limitation. I'm surprised the manufacturers didn't jump in even more but perhaps they were hampered by the pandemic. There have been significant supply chain disruptions in photography/videography industries for the past year.