Professional cards often support all of the gaming-graphics features that their non-professional counterparts do. Its just that certain extra features are enabled (as already mentioned, for CAD, etc). It doesn't have much video RAM, but should be able to run some newer games with limited settings.
Some of the best bang for buck at the moment for NVIDIA cards would be the GTX580 (or the GTX660 TI if you want a card that consumes less power, produces less heat). I run a GTX660 TI myself.
When it comes to raw power, lots of people at work (at a major software company) recommend the GTX670 (instead of the GTX680), but I'd rather use a normal GTX680 instead of a "binned-down" one...