ECC does a hardware checksum for error correction, so if memory errors occur it is possible to correct them and log to the firmware for possible memory replacement during a maintence window - so it is excellent for business critical servers. But I have seen ECC memory crap out and lock up just like non-ECC, but for the most part it does get corrected and logged. So you are really only decreasing the chance of a memory failure system crash...
Well let me stop ranting about this and say ECC does have a slight latency penalty, and is definitly not needed for a typical desktop / game box. The $ can be better put into quantity over error correction!