I never had one annoying dog that exceeded expectation
Most dogs are average , I rather have the average quite ones

only thing I have really seen working are barking collars and vocal castration , the latter is illegal in some countries