Couple thoughts from someone with a wide range of trail cameras across our property. I have very cheap ones and nicer ones.
For security, I would suggest No Glow cameras. That means they put out light we can’t see and don’t have a red light flash. You might could get by with a Low Glow, but the red light could be seen. I would suggest spending more than the minimum as well, because night pictures are the truest test of the camera. They all take good enough pictures in the day, but the night pictures can be very different.
How close can you put the camera? Some cameras only detect within 50ft or less and some at 100ft. The detection angle is important too. Some cameras need to be right on the target to get enough light to see.
I have a Bushnell Aggressor No Glow set up for security, that is probably $80 or so now. It has a long range and is good for night pictures. I didn’t like the newer version as much. They have a new model with two cameras to make night pics better, but it would be over $150. I haven’t tried it. I have Browning Strike Force something (older also) and I like it too. The detection angle is better on it. Night pics are similar. Can be had for a similar price or the new model again for $150ish. All these can be placed in lock boxes, to prevent tampering, which I do.
I have cheap $30-60 cameras as well. Some suck and I wouldn’t trust, and others would. It be bad up close. But for security, it is hard to keep it too close without being seen.
Hope this helps.