It'd work well with PC games that support 3D stereoscopic output, but on a TV with a console, the most you could expect is to have the flat image floating in front of the TV. the device would just offset each field a bit left or right to fool your depth perception into thinking the image is closer to you than tv TV itself.
with that said, no you wont be playing in 3D just yet.