I just took the leap recently and ordered a pair of carbon hoops. I broke the stock carbon hoop on my E29 within weeks of getting the bike, whereas aluminum usually last me a few months of abuse. I am hoping that the heavier duty carbon rims this time around will hold up. If not, back to aluminum.
But I have not had one fail and cause an incident, just the incident cause the failure. A friend of mine went hard over the bars when his wheel exploded when he rolled pretty fast into a reasonably large sized rock just off trail that he didn't see in the weeds. He was not injured, and I am certain the wheel would have failed in some form or another no matter what it was, but the explosion was impressive. We now call that trail "Leonards Rock" (short connector trail).
Rim brake rims right? I've heard that heat buildup on those is bad.
I remember one of the selling points of the wheels that came on my roadie is the small amount of aluminum used to dissipate heat from the brake track. 20,000 miles with a lot of climbing, haven't failed yet.