That depends on the features that you wish to have without needing an extra server to process the video for motion detection. In most cases it is only $30-60 more for a camera that can do a whole lot more. See this post…
If you can DIY then these esp32 based cameras are cheap and appear to have ready made firmwares to flash to it as well as example source code built into the Arduino IDE.