I have a 4" model 29-2, and it's worth owning just for its good looks. The trigger isn't as nice as some I've owned. I had a 6" model 629 with a smooth trigger about 20 years ago. It was much easier to shoot double action. My current 29 has a grooved trigger, and seems to have rough spots in double action mode.
The 29s are much easier to handle than the Ruger Redhawk. They also have a far superior trigger. The Ruger can handle hotter loads, and are accurate when shooting single action. I don't know much about their durability, but I doubt you'd ever wear one out. Never did get to shoot the big Colt, but they're so rare they aren't a factor.
One thing I can tell you, when that big cylinder rotates in double action mode, it can have an effect on your accuracy. You won't notice it when you're dry firing, but with six big bullets it there, the rotation creates momentum then snaps to a halt. It takes some getting used to. The Rugers are a bit heavier, so the effect is less noticable.