I have seen dogs go insane in no kill shelters after a year+ of living in a cage Anti Cruelty Society is an example of a good kill-shelter, they try all they can and will keep an adoptable dog pretty long.
Orphans of the Storm is an example of a bad no-kill. Most dogs live in dog runs with little outside contact but the dog walkers, go insane, and become incredibly protective over their runs. Furry Friends is an example of a very good no-kill. They take in out of state dogs and regularly rotate the dogs from the shelter to fosters, they work a lot with fosters.
An example of a bad kill-shelter was the place my dad worked at before I was born, the woman in charge tryed to make him euthenize dogs and cats for almost no reason at all (like "he lunged at someone") or "he looks like he has worms" and even more rediculus, so he reported her and she was fired.