For GPGPU CUDA rendering, only a Tesla K20 or a Quadro K6000 (both around $4000) will match (not surpass) Titan's capabilities. So from that point of view, the Titan is a bargain.
The main advantage of the Titan against other GeForce cards is its 6GB of RAM. The more memory the more complex the scene you can load on the card.
For OpenCL based renderers (like LuxRender) the Radeon 7970 with 6GB is much better than the Titan. Nvidia cards don't do OpenCL right. They're optimized for CUDA.
For OpenGL (mostly when it comes the interaction with 3D models ans scenes in most pro apps), the Quadro and Firepro are better than any GeForce or Radeon.