i mean that kind of makes sense for a security camera, right?

For an indoor camera used by consumers? Perhaps they only want the security camera turned on when they are not at home.

Is there any other camera without an off switch, consumer or enterprise?

I have a bunch of different cameras, nest, Wyze, Amazon - none have on/off switches. Just plug in USB for power and they start up.

At least they can be unplugged.

Simplisafe cameras have a powered privacy cover that physically blocks the lens.

If you get close enough to a CCTV camera that you can remove the panel covering the reset switch and network connection, you can just put tape over the lens.