I think you're asking too much of the DCS-930L considering it's low price point. This isn't a true "video" camera, rather it takes many single snapshots per second (think of a DSLR camera in "continuous mode" when you hold down the shutter release). You haven't been successful in finding where the video files are because there aren't any. In order to capture video, you need to run the D-View software on a PC. Period.
As for receiving many motion detection emails, yeah, I can relate. Just last weekend I was outside detailing cars, landscaping etc. By Monday morning I had just under 1,000 emails in my inbox. As I stated/complained in a previous thread, the motion detection function needs the ability to be set on a schedule (such as 8a-5pm Mon-Fri) so I only get emails while I am at work. Last week I had to tone down the sensitivity on one of my four cams because we were watching TV and therefore the overall room brightness was fluctuating constantly. Result? An email every 4 seconds for several hours. I also don't need an email every time I turn a room's light on/off, so again, the camera sorely needs the ability to set the motion detection to a schedule!
Sure, I could run D-View or Vitamin D or WebcamXP, but one of my main requirements is NOT having to run a PC 24/7 in my house. I've had my four DCS-930L cams for a month now and am mostly satisfied with the results. I get an email alert whenever someone walks up my driveway and when one of my cats jumps where they aren't supposed to (not that I can do anything about it at the time). The "live monitoring" function on my Android phone using the "myDLink Lite" application is also very slick.
In all, the system isn't perfect but it sure beats what I had before, which was "nothing".