Just make sure they have substreams and get a coral (or GPU) for detection. Then a pi could probably handle it.
I have enough processing to do it all on CPU (8 cams+doorbell) but it ramps up the power usage, so it was better to use the gpu I already had for transcoding, as detection.
Without you can still just record and overwrite. Not that it's extremely useful without detection and notifications.