Camera and optical zoom

What camera that comes with optical zoom?
Or what camera can I add an optical zoom lens to?

I would like to either manually change the zoom or programmatically.

The cameras I see are PTZ but I am not needing the Pan or Tilt part.

Thanks, I am new to RPI cameras.