This will depend on the objective to which you assign it. Remember that a mini spy camera aims to go unnoticed so it only serves as a “spectator” because you are only interested in knowing what is happening in the place that you place it, and you will surely keep this recording as infallible proof.
On the other hand, a security camera serves in a certain way as a warning. And a way to scare away. Since it is known that when a criminal tries to rob in an installation, security cameras dissuade him.