The novelist himself admitted that his infidelities ‘produced a duality and tension that became a necessary drug for my writing’