The good: Camera is waterproof to 10 feet, shock resistant to short drops and mild impact, and freezeproof down to 14 degrees Fahrenheit; also, has nifty Perfect Shot Preview function.
The bad: No manual exposure controls; slightly soft images.
The bottom line: If you need a camera that you can take snorkeling or skiing, then the Stylus 790 SW might be just the ticket, but you can find better image quality elsewhere for the same price.