I did it twice...neither one worked out, but I am not jaded. I am optimistic enough to believe that it could work. It was also fun while it lasted. I did enjoy the LDR very much!
What I did get out of one of them was a relationship for several years with the ex of one of my LDR's. Lots of fun times and memories.
So it was not all a bust.