i've tried a fair few in 3D this is how i'd rate the top ones
1.
avatar - stunning, amazing whatever you wanna call it really, 3D transforms the game into the best looking game i've ever played
Link to 3D screenshots
2.
batman arkham asylum - again really good 3D effect the whole opening section walking the joker through the asylum is just transformed into something else in 3D, works fine with max setting (no aa) and physx enabled too
3.
resident evil 5 - damn this games eerie in 3D, the crows are a little too spooky, plenty of nice 3D effects in this one, tentacles popping out the screen etc
4.
fuel - hardly the worlds greatest game but again 3D transforms it graphically, very nice 3D effect indeed, tried the demo then bought it for £5 i like the 3D that much
5.
left for dead 1/2 - played through 4 campaigns in l4d2 in 3D had no issues with eye strain or whatever even after 3 or so hours. nice 3d effect on the smoke on your gun and the blood splattering the screen
6.
streetfighter 4 - wasn't too impressed with this initially then i fired it up again and really like it now, there isn't as much depth as other games but it still looks really nice in 3D
Link to 3D screenshots
not sure if its possible to view those screens in 3D without the glasses mind
that's hardly an exhaustive list but its a start, most game types lend themselves well to 3D, need to reinstall tomb raider underworld as i saw the screenshots nvidia provide and that looks to be a good one. really though any 3rd person/1st person or racing game is gonna look excellent in 3D, some games have a few issues like you may have to turn off the odd effect but nothing too major really, the ones listed above are pretty much flawless in 3D