If you're looking at Hikvision stuff, they make the 2032F which is a 2032 with an SD card slot.
The turret you can twist off the bezel, but you have to undo a screw in order to even turn it.
With the dome you can also undo it, but you need to undo 3 screws. if anyone wants to disable them a spray can would work evenly well.
I don't like the idea of on-board storage, some people steal the whole camera (yes it has happened before). Unless it's recording on the camera as a backup.
Also, domes can suffer from IR reflections. It does depend on how you mount it and what is near it. If it's an ideal place you won't get any IR reflection, or minimal if thats the best place you can mount it.