On the Horizon Instability of Extremal Black Holes and Black Branes