Keep it simple.
The stuff below can be built for around $100 (the UV is extra) and takes replacement cartridges found in most hardware stores. Do NOT buy a proprietary canister size.
Get two of these:
https://www.amazon.com/Pentek-10-Sta.../dp/B003VT7ERY
Plumb them together on the inbound water. Put a 5- 20 micron cartridge in the first one for sediment.
https://www.amazon.com/dp/B082WS9NPH/?th=1
Put a one micron activated charcoal filter in the second.
https://www.amazon.com/GOLDEN-ICEPUR.../dp/B01N1IJ5V1
(Put a third single body under the sink and the same one micron filter if you're really paranoid.)
The first filter keeps your second filter from clogging quickly. It's disposable and when the water starts slowing down, change it.
The second filter is for taste, chlorine, etc. May help with some other things but read the label carefully.
One micron or less is what's required to filter out Giardia and other wee beasties (protozoa). This is what's in a Sawyer filter for camping for instance.
Extra worried:
To really, really kill everything, you need a UV cell on the incoming line, before or after the filters. These take AC power to provide enough UV light to handle the flow rate required.
https://www.amazon.com/HQUA-TWS-12-U.../dp/B07JLNYH49
I've run this essential setup at a camp pulling water directly from a lake with no ill effects.