<< How does this compare to above consumer products/professional cards in the same price range(or slightly higher)? >>
My last Pro graphics card was a Diamond FireGL1000, which was OK(it worked), but no comparison in performance/image quality. I swapped that out for a V3 2000 PCI, which was OK for photoshop/premiere but unacceptable(worked) in Max, but wouldn't work for Maya at all.
I would rate the Radeon as a very good prosumer level card, and I doubt there is a card that can match it feature for feature for the price(It does everything well), but certainly the nVidia cards work VERY good in Maya and Max, but you would want to likely look long and hard for a model with acceptable performance in photoshop if you work with high resolutions, and the VIVO capabilities are no match for the rage theater. Matrox g550 would be great for photoshop/premiere, has dual head support, but not sure it would be a 3D application solution.
3Dlabs Oxygen VX1 is a pro level OpenGl card and would be a great for Max, and Maya and from what I've heard, pretty good in Photoshop/Premiere as well. If it weren't for gaming and VIVO, this card would very likely be my pick in this price range. This is an awesome entry level pro card.
My experience lies with what I use, and I can recommend the Radeon for sure, but you will want to hear from others that actually use the other cards so that you can make the right choice for you. Good luck.