Some sample footage from the Olympus TG2 point-and-shoot camera. It really does go down as much as 50 feet. Overall the footage is not bad. There is no way to lock the focus or the exposure, and that's a significant concern.
But for the convenience and its compact size, it's quite amazing.