Wendy D. reviewed The New Science of Strong Materials or Why You Don't Fall through the Floor (Princeton Science Library) on + 10 more book reviews
A little outdated, I think, but still gives quite a bit of insight into why particular materials are used for different applications.