Only one famous story and I'm repeating it from earlier in the thread:
Mr. Johnson (Johnson & Johnson) got dripped on his head at his first dinner party from a leak on a rainy night in his new FLW house, and he calls FLW and complains, so Wright answers Mr. Lever, "Well, Herb, why don't you just move your chair."
I think Wright had an idea that the "falling" in Falling Water would be the house. It's an impossible building site and like the roughshod finish on the outside of the Guggenheim, it's not perfection.
Other than that, I know the Stoner House on Hollywood Blvd. when it winds up through the Hollywood Hills (it was a few doors down when I lived there in the 60's) experienced no leaks and Talisman West, the main drawing room in the Arizona desert where there are sometimes torrential downpours has never leaked. That's a contractor's problem, not the architect.
The house in California seem to have little deterioration problems other than normal. Several of the images I posted were actually from realtors when the houses came up for say. Of course, Hollyhock has it's own park and is a California state monument.
A friend of mine was an architect in Laguna Beach and I once did some light in his design for a private home facing the ocean. The stairwell had a huge skylight. The first rain, it leaked.