Not trying to sound (too) snarky, but the fact that there is an article on hacking a camera to do that kinda tells you that a boxed solution to do mostly the same things doesn't exist :)

No worries, my initial comment might have been on the wrong post ("hey, I see you hack cameras but if I don't have time for that, where can I buy one with acceptable out-of-the-box behaviour?") but I felt the subject was a bit related at least, and I don't know any of them so I asked :)

Lots exist, just not cheap :)

Yep, I should've been more explicit, but I was counting "be cheap" as part of "mostly the same things".

Recently bought a Nest camera since it seemed like a DIY approach was going to be harder than I thought. Might end up returning it if I can get this to work how I want.

I have a couple of Xiaomi Yi cams, which out-of-the box stream to a mobile app, don't require a subscription, and will save video locally to an SD card. They are cheap and cheerful (but you would want to keep them behind a firewall). That said, this hack clearly offers a lot more functionality (I think I will replace my Yi cams with these and relegate them to recording raccoons in my backyard).