Purchasing a home water softener can be confusing, so it makes sense why people often rely on a trusted brand, like Costco, to help. But there are drawbacks.