It seems that 3D is better suited to slow-moving, large-scale images than typical Hollywood action sequences. I can't stand 3D action movies, they make me dizzy. Especially when it's combined with shaky cameras!
But Gravity was awesome, animated 3D movies from Disney/Pixar are generally OK, and I really enjoyed the 3D version of Titanic that James Cameron produced in 2012 for the 100th anniversary of the sinking. (It's the same movie that came out in '97 but converted to 3D. Most of the time, you don't even realize that it's 3D. It's quite subtle.)
Gravity was spectacular in 3D, but I have a much larger list of films (many of which aren't great) that have immersive and not distracting 3D. Off the top of my head:
