Slow, local streets are relatively safe because of the slow speeds and the priority on building places that cater to people and businesses rather than moving automobiles as quickly as possible.
The 'in between' things, "stroads" are what tend to be the worst of both worlds. They do often include some token bike/pedestrian infrastructure that is not very safe, and they include lots of places where other cars exit/enter the road and turn lanes and just a lot of potential for bad interactions in unexpected ways.
The Strong Towns folks do a pretty good job of outlining this, and in terms of fixing it, I've seen some interesting stuff related to street design in the Netherlands.