ECC was designed for servers crunching scientific data and large databases and such that were very error sensitive. It also began life when ram was less reliable than it is today.
In times past, you could find support for it in some mainstream mbs as well as almost all server mbs.
The average computer does not need it. There is also a slight performance penalty in using it as it performs the the error check and corrections functions realtime during all operations.