It very well could have just been my eyes or the type of glasses I was using, but I was far from impressed in the 3D on the PS3 games I played.
It looks much better with the Fanboy Vision glasses off, trust me.
I didn't play too much of it but I played a bit of BlOps with a friend on his 3D TV on a PS3 and it looked pretty cool.
I think it's more a matter of "not enough people had/wanted to shell out the money for a 3D TV and glasses" than it actually sucking.
Which is why Sony introduced newer, lower priced 3D TVs. Certainly not as big as a gigantic flat screen but large enough for gaming, plus it demoed that sweet 3D splitscreen tech.