Think of it this way: you have a full Linux machine running on the Pi. Any usb web cam that works with linux (most that exist) will also work with this application if plugged into USB. The real advantage of lower level hardware like the built in camera module is for stuff like AI computer vision where you need direct access to more of the data processing stream instead of the preprocessed and compressed output of a typical USB webcam.

This is actually how major companies solve this problem too. Laptops and cheap tablets often have a 4 wire connection to their built in camera. These are just connected to an internal USB bus. The manufacturer doesn't even mess with a low level (better featured) camera and all of the programing involved.