It's a neat effect that's almost never worth the compromises for me. I don't want to be wearing glasses, or trying to keep in that tiny 3ds sweet spot, or anything like that. If we had holograms or someway to deliver the experience in a better way, I'd be fine with it.
still, I found it's beneficial in first person games, since the effect creates the sensation of having a greater field of vision. helps in other games too, but most noticeable in first person games.
and this is more on the 3DS and PS3, but these systems are too weak and often times it's "the 3D effect or ..." I tried shadow of the colossus in 3d and as incredible as it looked, the frame rate became worse than the the ps2 version. Went from 30fps to what felt like half of that.