The producer, who worked with the likes of Johnny Cash, Tony Bennett and the Red Hot Chili Peppers, passed away on Tuesday in Saratoga Springs, New York