Ok, you will need a 3D ready monitor. You can't just use your screen.
The $200 NVIDIA glasses are ESSENTIAL for 3D pictures, its not the same as those red/blue glasses you get at the movies.
And lastly, most games made nowadays are 3D. BFBC2 looks quite good, along with COD:MW2 and NFS Shift. I've never played SC2 on 3D though.
Is it worth it though? A 3D screen would mean you have to downgrade to a 24" monitor which is quite a bit more expensive than a normal 24" PLUS the glasses.
IMO, its not worth it. My friend has a 3D setup and while it IS quite cool, it hurts your head after a while. Not worth the money, unless you have a multi-screen setup that they have on display at some stores.