Not a water treatment system as those being described in the thread but I have installed and used a water filter in my house to prevent sand and metal deposits to enter my home pipes, as the main is a very old galvanized tube.
It cost around 60€ and the instalation is pretty straigh forward if you are at ease with tools. The kit was composed of a stainless steel cartridge and a clear filter housing. A cartridge lasts about 2 years, more if routinely cleaned, and I had the option of cheaper fabric-like filters, discardable.
The results, for me personally, besides removing the solids, were negligeable but my partner is a water taster and was constantly stating the water tasted better after I installed the filter.
I went to a few stores, asking questions and comparing answers and solutions. I was not in need of a complex system but regardless I was presented with very exaggerated solutions and more basic and down to earth approaches. A serious hurdle I had to face was insisting that the system had to be easily instalable and maintainable by myself; most people tried to convince me to have everything installed by a plumber, no matter how simple the solution was.