Kinda surprising. We have 4 good ones (out of 5 shops). They all mess up every now and then, but they are indeed heavily involved in the cycling community, hire mostly cyclists, and know their stuff.
They're not terribly price competitive (they try, if they know you), but they make up for that by fixing my bike every now and then.
Maybe my standards are too low. It does seem like the new employees during the summer are often, um, more difficult to get help from. If you want to test the heart of a bike shop go in during the winter to get some winter gear. If they're cyclists they're still riding.
Obviously this only works if you have winter, and not an extended jacket season.