R&A chief executive Mark Darbon says Royal Porthcawl's hosting of the Women's Open made for a "wonderful week" in south Wales.