Honestly, bleach isn't bad if you stick to the Red Cross recommendations. It's like drinking swimming pool water.
For years, I've filtered through a bandanna, or coffee filter, then added a couple drops of bleach per 1.5 liters and have never gotten sick. My daughter bought me a Life Straw for Christmas and I plan to use it on my next trip. But...mountain/desert spring water or desert creek water is crystal clear and bleach is all I've ever used. Sometimes I just drank it and never looked back.
I worry most about ag runnoff and river water at city level. Viruses and chemicals are my concern. Filter, charcoal filter, and bleach should take care of it. Municipal water departments probably don't go that far.