Motioneye is worth it if you've got any capability to self host and all your stuff is on the same network since it's just a DVR that sources camera streams from the network and handles all the detection and such so the devices pushing the cameras don't have to. The critical part is that if you self host anything you can just throw it in a docker container and then use pi zeroes or ESP32-CAMs to provide the streams while it does all the motion detection, etc.
If you don't want to bother with that just track down a Wyze Cam V2 and run this firmware on it for good motion detection, monitoring etc that works entirely offline. You can always throw it into a motioneye setup later on if the need arises.