By “high quality” you mean big sensor? 1” is possible - https://github.com/will127534/imx294-v4l2-driver and see OneInchEye based on the IMX283.

While many camera sensors use MIPI/CSI, you need enough lanes to transfer the data, the driver support in the kernel and other pipeline bits to get good images from the bayer. Almost all “real” cameras use ASICs or FPGAs to clock out the images. Additionally sensor companies are miserable to deal with in small volume and datasheets are under NDA. You’re much better off buying a camera from a machine vision company over USB3 or Ethernet, but you need one which properly enumerates as a video device (many do not). You can still do nice stuff like hardware sync/trigger from the Pi.