The guitarist, who died Thursday at age 74, joked his way through rock & roll with a wit and laugh that rivaled the best comics