My 500' well is about 2 and a half years old. The first year my water was cloudy about 80% of the time. The only filter that would clear it up was 1 micron or smaller. It was almost always cloudy, and I didn't want to filter the whole house because of the loss of water pressure involved. I first put a tap filter on there that had to be replaced about every month or so. It was inconvenient.
I then bought a GE 2 stage undersink water filter at Home Depot for about $125. The filters cost about $34 for the pair and I change them out every 3 or 4 months. The setup included a faucet that I had to install on the back of the sink to one side, so it is only used for drinking water - not for regular use. It only puts out about 1 gallon per minute, which is OK for drinking water.
Our water seldom ever clouds up anymore, but this setup has worked fine for us. The drawback of course, is that our toilet tanks collect a gray mud in the bottom over a period of time, and I suspect the water heater is the same. I dug out about an inch of mud out of each toilet tank after about two years of use.
The first two or three months after the well was drilled, and the water was mostly cloudy the pump went out and they had to pull it. I had them take a 21' section of galvanized pipe out, therefore raising the pump that much, hoping to solve the cloudiness problem, but it didn't help. Only time did.
My well is 500', and the pump now sits at 399 feet, formerly at 420 feet.