Earlier quoted context omitted.
Neither cameras watching gas stations nor cameras watching your front door are "police cameras". They are privately owned cameras, but feel free to expand on what makes these cameras different in your opinion.
Police can get footage from Nest cameras, indoor and outdoor, without owner permission by applying directly to Amazon, and users can't opt out of Amazon's "Rekognition" tool that is always on and alerts police when a face on their wanted list is recognized on a camera.
So that brings us full circle to police are able to get footage from your CCTVs without your permission too by applying for a warrant directly to the court.