Although he was a star locally, the Detroit rocker had been struggling for years to break out nationally—until he formed the Silver Bullet Band.