Catch up Jimmy, I've been doing this ages now
The promise of the 3D gaming is great, however the reality however is a quite sober affair.
The trade off for many games to display 3D is too much for the current hardware with a few odd exceptions.
Enslaved drops resolution, and the 3D effect is not mind blowing. Though as it uses TrioViz technology it's not as bad as something like Killzone 3 which steps down it's resolution considerably when you utilize it's 3D mode. Basically your turning the game into a 480p game, and whilst you get the 3D effect, you also get low resolution, lots of aliasing issues, and a general lack of clarity to what in 2D is a great looking game.
SOTC & ICO
Jak & Daxter
Sly Racoon Collections all are 3D enabled, but don't bring too much to the table by being in 3D. There is still a performance deficit over the 2D version even in these instances, and SOTC is at times a slide show due to it's poor optimization (heck even in 2D at times).
MotorStorm : Apocalypse is also 3D, and again provides dimension, however due to the mud fuddled nature of its graphics and the collision damage with objects in this iteration - it doesn't actually provide anything extra.
Ridge Racer 7 - with patch - is Ridge Racer in 3D basically. Same game with a small bit of added depth.
Super Stardust - whilst works very well because of the fixed distance away from the planet and such the 3D effect isn't as dramatic, though it's one instance where there isn't a negative impact because of the 3D
Wipeout 2043, with patch - very good use of 3D with small trade off of 720p instead of 1080p. Works well in fairness to it.
Resistance 3 - again another Sony title that drops lots of resolution to add the 3D and because of it suffers in a way that whilst it now has shiny 3D it looks like crap, and the framerate also takes a good knock.
Batman : Arkham City - surprisingly I LOVED this game in 3D. In fact personally because they adjust some of the post grain filters in the engine whilst 3D is on, it actually looks better than it does in 2D with a better clarity. Also the framerate doesn't take a hit or the resolution either. This so far is the best 3D experience game.
As for causing headache etc...
Depends on the TV, how it handles crossover, and the settings it has. Personally I went for a Samsung LED 3DTV because of the ability to take 2D images and 3D'fy them. In some instances such as Killzone 3 this actually makes the game look almost the same as the native 3D option without destroying the resolution, textures etc...
As for movies.
Personally I prefer the 3D at home over the 3D at the cinema as I get a more fixed experience. At the cinema you never know where your going to be sat and at what distance and viewing angle all of which can effect the 3D experience. One time at Avatar i was sat at front row and the 3D was headache inducing being so close to the screen.
My 3D blu-ray collection so far....
cloudy with meatballs,
nightmare before xmas,
monster and aliens,
shrek 3D collection. All 4 shrek movies in 3D
Christmas Carol,
Bolt,
Alice in Wonderland,
Rio 3D,
Lion King 3D,
Tangled 3D,
Beauty & Beats 3D,
Clash of the Titans 3D,
Priest,
Hugo 3D,
Puss in Boots,
Tintin,
Animals United,
The Hole,
Resident Evil - Afterlife,
How to Train a dragon
Captain America,
Thor,
A monster in Paris,
Despicable Me,
Narnia - Voyage of the Dawn Treader,
Green Lantern,
Harry Potter Deathly Hallows part 1 & 2,
Transformers - Dark Side of the moon,
Underworld Awakening,
Pirate of Caribbean : on stranger tides.
some films work better than others, but on the whole the 3D works very well.