After producing Cream and others, he became the bassist for one of rock’s first hard rock bands. But then his wife caught him with a younger woman