Just wondering...?
Seems to me that the discussion of getting a warrant quickly presupposes that there is probable cause for the warrant, in the case of the suspected DUI driver, the evidence that he appeared to be unsteady on his feet, smelled like he was drunk, had glassy eyes (did I miss any of the standard ones?) and he had caused an accident according to the witnesses and positioning of the vehicles.
In the case of the homeowner refusing entry for "a sweep" of a house in a fishing expedition of a 20 block area? While judges are human, I'd hope that they'd at least give it a little thought.
IANAL...