City of Berkeley has a pretty hard-... inspection program (separate from the rest of the county) and differentiates between minor and major violations (for the same list of events). I really don't care about minor violations, because it could have resulted from someone not shutting a refrigerator door properly 15 minutes before an inspector came, or someone not being able to check on the soap dispenser in the bathroom after a huge customer rush about the same time as the inspector came.
I don't think they hesitate to shut a place down on the spot, if need be. Alameda County also seems to have a decent program.