One area that is clearly overlooked here is that you can have all the filters you want, even down to removing viruses in real time (albeit slow). But there are water sources that are simply not safe to get drinking water from because they can contain a whole cocktail of chemicals not even an active charcoal filter will remove. Like built up areas, farmlands etc. Also despite the fact Aus water treatment is top, the infrastructure it travels through is old and decaying and could harbor all kinds of stuff that could have longterm effects, but then stuck in traffic each day also does you longterm harm...
Dealing with water is dead simply, first you clean it with a 5 and 1 micron filter (I use a cheapy sediment and a BEST)
This takes out the dirt, sediments, microplastics, some metals and chemicals and probably some bacteria.
Then you disinfect the water either by boiling, added chlorine ( best to add another best filter right before tape), or other options.
However I have a portable setup that lives with my portable joolca setup and I rigged up multiply sawyer squeeze filters in parrelle (each Sawyer looks to handle 1.8L/min safely from my test), added an inline stainless tape and pressure regulator (sawyers can only handle small psi) to mimmick gravity feed, so I can filter out all bacteria without burning alot of pump power with just one slow filter. I use a industrial grade pump ($$$) as most pumps are low duty cycle and I got up to 250L to fill... feed by a small lithium and the whole shebang is rain proof.
Finally if the water source is really suspect with viruses I break out the lifestraw mission gravity feed setup.
It uses two 12L missions hooked up to a sturdy camera tripod (15kg ball weight limit alone!) That can feed down to a 20L jerry, water bladder, or just a stainless drink bottle, all sealed connectors to prevents stuff crawling in. Sadly no one makes a good collapsible 20-30L bucket with outlet, no room at all to carry a solid one. 0.02micron=really slow rate. How do I know these work? Because these kinds of filters are sold to third world countries with poor water.
Overkill? Maybe. viruses are said to be an issue only in developing countries and dont last long in open waters in developed countries.
Years back we used a 60L stainless keg to boil up river water, a lot of large stuff, nowadays much better lighter options available.