At least in the Netherlands there’s the same loophole as in the US: the police can give a camera to a private party, point it to the street and get access to the feed.
Not sure how you’re going to hang up a Ring doorbell then. And the police surely doesn’t mind if you ‘accidentally’ capture ‘part of’ public space, as long as you share your images with them.
This matches precisely none of the practical experience I've had. The police is the police, they're going to be evil bastards when they can get away with it - but in this case I'd like to see some legislative proof that this is actually true.