After trying a few games in 3D (Wipeout and De Blob 2 specifically, and Child of Eden) I have to say... What the hell were people hating on?
I've only tried passive 3D, but it's such a huge difference that I'd like to see every game in 3D. Everything looks so much more alive. The glasses aren't even that uncomfortable (although not preferred). I had a friend over who didn't like 3D in the movie theater, and he was blown away. He said it was like he was on acid.
Someone said 3D was like the jump from black and white to color, and that's pretty much how I feel. There's no way I'd buy a TV these days without 3D, and I went in expecting to hate it. Only negative is not many games support 3D, and there's some ghosting.
I also have a 3DS but it doesn't really compare at all to big-screen 3D, it's much more subtle.
I just bought a 3d tv myself, although the 3d feature was just a bonus for me, I was really after the PQ of the LED tv that I bought. I was pleasantly surprised at how much I enjoyed 3d after dismissing it as just a gimmick. Granted, I have not tried it with a game yet, but yeah, I see your point. I guess it's just something that varies from person to person.