Nope, and in case of crime, most local police forces can simply walk into local stores and request recordings from the last X days, so quite why they'd need illicit backdoors, I don't know.

I'm also entirely fine with this.

Backdoors in cheap CCTV being accessed illicitly at a mass-level is an entirely different problem, and one which I'd agree would need questioning.

I doubt there's much value in that concern for another decade, until the majority of CCTV cameras are ultra high resolution/30+fps, which they're not.

Not to mention camera technology that only records “junkies and thieves” and not the thousands of innocent people going about their day. There is nothing ok about pervasive, constant surveillance of law abiding people.

Any CCTV system that's air-gapped from the internet (records to local storage only) reasonably meets this definition.

Yes, there are possible exfil paths, but not ones that can reasonably be executed on a large scale. Realistically, the danger from break-in and hard drive theft (or warrant/subpoena) is greater for the average user.

Raspberry Pi Camera Module?

Unless you believe governments have backdoored SSH, I would say it's good. Definitely not a turnkey solution though.