It's unfortunate that technology moves on, because this is a card that looks fast, but compared to even a tiny integrated GPU in a sandy bridge i7 this beefy card loses out.
Once upon a time the 8800 was a legendary card, it was head and shoulders above what came before it, and AMD (nvidea's main rival) couldn't compete with this product. It hit the sweet spot of price/performance delivering a lot of bang for your buck.
The card looks amazing, and runs quiet and cool thanks to the huge fan on the front. It is faster than a stock 8800gts as this is the second edition overclocked version- the fastest card out at the time. It has 640mb of vram, which is still impressive today.
it won't run the latest games at high settings, but it will let you play things on low settings, and older games with ease. It supports cuda so it's useful for running with a video/photo editing machine, and it works fine for 3d modelling and animation.
I recently sold mine for about £30, so if you want a card to look cool, or to be used for video editing where you need dedicated memory rather than integrated then this card might be a better option than whatever £30 will buy you brand new.