The 957 in action
This is a sample audio clip taken from a corporate production I am working on that may be a useful example of the capability of the old Sony ECM-MS957 Mid-side stereo microphone (also known as the ECM-957PRO). With its 3.5mm TRS consumer-style connector, it's ideal for connection to DSLRs offering the 3.5mm stereo connector (with or without plug-in power) for microphones.
This clip is recorded directly into the Sony A7R mirrorless camera with the microphone shock-mounted atop the camera's cold shoe as per the picture. In the scene, two female Police officers are describing features of Blackwater, a small town in Queensland Australia.
I believe this shows the versatility of the microphone as both an ambience and dialogue mic. In a pinch, it could be used on a pole as a relatively directional cardioid in place of a shotgun. Very handy if you're travelling light.
As true with any microphone, choosing the mounting options and wind protection also help a great deal. I purchased the Rycote windjammer for the 957 from B&H.