Not really. ES Explorer buffers the file content but it doesn't copy it whole before making it available as a HTTP stream using its internal web server, it becomes available instantly no matter how big the source file.
Media House uses a completely different (and better) approach by serving (streaming) content using DLNA so it doesn't actually use the CIFS protocol at all; the end user experience is much the same though, so long as you're displaying the content on the Android device rather than on a remote renderer like (say) a smart TV.
For my uses I really can't think of any advantage to mounting a CIFS share on Android the way I do on a desktop system. On the desktop system that's pretty much the only way to access the content, but I can do that anyway on the Nexus without mounting it first.