I don't think I've ever come across a camera that supports pushing footage to an SMB drive. It does seem that every device manufacturer wants to suck you into their cloud service... for the larger firms it's probably just a way to get our data. For the startups you'd expect they wouldn't want the bother of running a cloud service, but these days your best bet for being snapped up by Google / FB / Amazon is to bring lots of subscribers to the table.

Anyway, maybe there are cameras that support RTSP or HLS, and can be set to stream only when motion is detected, to save the battery. You'll need a CCTV server that can deal with cameras which go up and down all the time, but those do exist.