I agree that, unless you're doing something super-sensitive, it's probably not worth it; it will eventually save you from an app (or OS) crash, but only VERY rarely, so it's probably not worth the added expense and slightly slower RAM for most folks.
To give a positive example, OSX's server monitor loggs errors that were caught and corrected by EEC RAM. I have an XServe with EEC RAM running at work, and in the past 6 months of 24X7 fileserver use, it has caught and fixed exactly one error.
Now, that error could've brought down the entire server, so it was worth it in this case (and there will probably be another a few months from now), but for a home computer I doubt you'll ever notice.
The 3D rendering is an interesting example of somewhere it *might* be useful; if you're running renderings that take days, it would suck terribly to have it crash near the end, and since RAM speed probably doesn't make that much difference (processor bound, after all), EEC might be a worthwhile investment since you're probably spending heaps on hardware anyway.