Localization Phenomena in Networks: Implications for Fragility and Dynamic Response