These cameras divide into two main groups: Firstly the webcams that connect using a USB cable. these have to be connected to a computer or Raspberry PI board. Secondly are the camera modules that connect directly to Arduino and Raspberry Pi via ribbon cables.

3d scanner part Raspberry pi camera ribbon 300	https://www.digikey.co.nz/product-detail/en/adafruit-industries-llc/1648/1528-2107-ND/7035020
3d scanner part Raspberry pi camera ribbon 610mm	https://www.digikey.co.nz/product-detail/en/adafruit-industries-llc/1731/1528-1791-ND/6238161
AV Gear Logitech C920 HD Pro Webcam 15-megapixel snapshots 1080p video calling H.264, Autofocus, Stereo Mic	https://www.pbtech.co.nz/product/CAMLOG1857536/Logitech-C920-HD-Pro-Webcam-15-megapixel-snapshots
16m pixel camera	https://www.digikey.co.nz/product-detail/en/raspberry-pi/SC0261/2648-SC0261-ND/12339164
8 m pixel camera	https://www.digikey.co.nz/product-detail/en/raspberry-pi/913-2673/1690-1012-ND/6152811
lens telephoto lens for above camera	https://www.digikey.co.nz/product-detail/en/raspberry-pi/SC0123/2648-SC0123-ND/12339166
lens wide angle lens	https://www.digikey.co.nz/product-detail/en/raspberry-pi/SC0124/2648-SC0124-ND/12339169
thermal camera 768 (32 x 24) IR pixels that can detect temperatures from -40°C to +300°C with approximately 1°C accuracy and at up to 64 FPS	https://www.digikey.co.nz/product-detail/en/pimoroni-ltd/PIM365/1778-1231-ND/9606191
Computer usb Camera for Raspberry Pi 2 Model B/B+/A+ Raspberry Pi 3 3B+	https://www.aliexpress.com/item/Computer-usb-Camera-for-Raspberry-Pi-2-Model-B-B-A-Raspberry-Pi-3-3B/32717800770.html
ESP32-CAM WiFi Micro processor 5V Bluetooth with OV2640 Camera Module	https://www.aliexpress.com/item/10pcs-ESP32-CAM-WiFi-WiFi-Module-ESP32-serial-to-WiFi-ESP32-CAM-Development-Board-5V-Bluetooth/4000926139492.html