The first one where the police uploaded videos and wanted viewer information is absolutely egregious and makes me wonder how a court could authorize that.
The next one, which I didn’t fully understand, but appeared to be in response to a swatting incident where the culprit is believed to have watched a specific camera livestream and the police provided a lot of narrowing details (time period, certain other characteristics, etc) appears far more legitimate.
On the one hand, a narrow warrant that reveals a lot of people (classic example are warrants on motels to provide the names of everyone who checked in on a certain date, or was registered on a certain date) are certainly constitutional and have been upheld many times.
The first seems, odd.
Even better might have been to directly link to some service that they already control on a honeypot URL, and then gone after the ISP for customer details.