For 2D movies, leave it off for sure. But for 3-D, you may find that leaving it on a low or standard setting will reduce the flicker. Many professional reviews of the various Sony sets with active 3-D have noted they saw noticable flicker until this was enabled.
I had a Sony HX800 set for awhile, and the glasses had a noticeable flicker even in a dark room. I couldn't enable this setting (it was a first gen unit) so I had to live with it. All other Sony sets seemed to have this flicker also, which is strange since I have not noticed any on other brands such as Panasonic or Samsung. Some people seem to be more sensitive to this than others, YMMV. I got used to it after a while, but when I moved on to a Samsung set, I was glad to see I couldn't see any flicker at all.
The best at home 3-D I've seen, bar none, is on the Sony 65" X900 UHD set. It's full 1080p in each eye; same resolution as active sets - but without crosstalk, flicker, batteries, etc. It's truly better than the theater or any other 3-D set. The LG UHD models also look excellent. If you've only seen passive in 540p, you need to reevaluate the tech on a 4K set. It's a huge improvement. It simply blows away active.