I have never managed to use css3pie without it totally messing up all my other CSS.
I've used it on one site and it worked fine there, but admittedly that's a tiny sample size.
it has no support for color-stops in gradients, but your right - would be enough for most people. but since the audience are web-designers, for whom 2 color-stops would be a limitation, it's no option.