Its coming out Jan/Feb in the US according to the latest information.
There are TONS of reviews/faqs/specs all over on the card, and even some on nvidia's site. I suggest you check those out.
Logically it should be quite good for 3d and is be touted as more then a gamer's card. Of course the later Quadro based on the same technology will be the big professional card. The FX does have the native Cg langauge and everything and some apps, like XSI, will be fully integrated into that while others (Max, Maya) will have plugins.
I'm personally planning on getting that card myself as I think it will have good 3d app performance and will kick ass for other things too
Check the Launch video off of nvidia's site for lots of interesting stuff to see.