If you use the official V1 camera (ov5647), V2 camera (IMX219), and the HQ camera (IMX477), you can just plug in the camera and play.
If you use third-party cameras, the support camera size is as below, and please use libcamera stack.
You need to modify the config.txt file and add the configure line according to the camera type. Raspberry Pi currently sells two types of camera board: an 8MP device and a 12MP High Quality (HQ) camera. The 8MP device is also available in NoIR form without an IR filter. The original 5MP device is no longer available from Raspberry Pi

Raspberry Pi is transitioning from a legacy camera software stack based on proprietary Broadcom GPU code to an open-source stack based on lbcamera. Raspberry Pi OS images from Bullseye onwards will contain only the libcamera-based stack. If you use the newest Bullseye Raspberry Pi OS, the libcamera is pre-installed. If you want to use the legacy camera stack (Raspicam), please move to the Raspicam guide.

Useful Link:

https://projects.raspberrypi.org/en/projects/getting-started-with-picamera

Features:

1. A full range of Raspberry Pi boards
2. Easy to use
3. Color: Black
4. Compatible with Raspberry Pi

Packages Includes:

1 x Waveshare IMX378-190 Fisheye Lens Camera for Raspberry Pi, 12.3MP Wider Field Of View