The local hard rock and heavy metal scene in the San Francisco Bay area catapulted many groups to stardom, including Metallica, Exodus, and Testament