3D for movies is still going strong. For some reason it's not included in any 4K Blu Rays currently on the market. Which is dumb, because movies like Mad Max Fury Road would be amazing with both 4K plus 3D.
Side note - get a TV that uses ACTIVE 3D rather than passive. The glasses are more expensive and require batteries, but the quality is greatly improved. As they only let you see one frame at a time, you lose the blur effect that often annoys people with fast-moving films in the cinemas.
In movies, having 3D that's actually good is partly down to the filming method (true versus converted) but mostly down to shot composition (positioning of foreground and background objects.
In games, you're usually in charge of the camera, so 3D works very well.
The main benefit of 3D is immersion. Every object in front of you feels more real, and (surprisingly) more noticeable. Random peripheral objects like a lamp on the wall or dripping water from above get your attention more and it makes you appreciate the design of the world.
So from the above, I would genuinely say that
3D is underrated and better than 4K. There, I said it.
For console gaming, 3D died in about 2012. The last AAA game to release with the feature, I believe, was Assassin's Creed 3. And you should NOT play that game in 3D on PS3 - it caused major deterioration to the graphics, including a lot of aliasing and geometry completely disappearing. Which is weird considering how great the 3D was in Revelations just a year before.
Another bad example of 3D is Halo: Combar Evolved Anniversary on 360. They balanced that completely wrong, so environnments looked really flat but as soon as you get a gun it pokes your eyes out.
Also don't bother with Batman Arkham City 3D on consoles. Even with the depth turned up to full, you can barely see a difference most of the time. But later I played in 3D on PC, where you can configure the settings to your fancy, and it was amazing.
But here are some examples of console games that were great in 3D:
Uncharted 3
Call of Duty Black Ops 1 & 2
Killzone 3
Wipeout HD
Motorstorm Apocalypse
Assassin's Creed Revelations
Ico & Shadow of the Colossus HD
Resistance 3
I never tried Crysis 2 in 3D but I imagine it was pretty good.
I was really lucky to get myself a 3D TV that ticked all my boxes for a great price in 2014. Unfortunately this was just
after 3D console gaming had died. Since then I've basically caught up on all the good ones.
However, since I discovered a delightful piece of software called TriDef, and set it to side-by-side mode and used the Convert button on my remote, I've been playing a lot of PC games in 3D.
Anyway, I'm going to take this opportunity to post a few screenshots (anaglyph for your convenience, but normal colour on my TV) that I've taken in the past few months.