I've seen RE4 (The Movie) in 3D, was it fun? Yes, hell fucking yes, It was like i was dodging danmaku throughout the whole movie. Did it really improve the visuals? No, hell no, after around an hour with the glasses on my fucking head looked like it was gonna burst open and I had to remove it, but I couldn't see anything clearly on the screen without the glasses, it was like seeing a movie in 120p or something. So I put the glasses back on and just beared the headache, because I paid to see the movie (obv), cue a fucking ultimate headache after the movie ended and it only really passing completely two days later.
My point being: Is it extra enjoyment in a movie? Yes, it is, because you don't have to do anything but WATCH, and even then there's its drawbacks. In a game, it's distracting and you would be dying a lot because OH LOOK GLASS SHARDS ARE COMING TOWARDS ME IN A 3D EFFECT, INVONLUNTARY EYE CLOSE WAIT SHIT I SHOULDN'T HAVE CLOSED MY EYES OPEN THEM BACK UP OH, I'M ALREADY DEAD, CONTINUE. See what I mean?