Years ago my friends and I took a trip to the Wallowas in Oregon near the Idaho border. We were mostly camping backcountry with a few nights at campgrounds. I filtered my water at the campgrounds, but when we went backcountry, I was about to just put my bottle in the stream and one of my friends stopped me and told me to filter it and to never just drink out of a stream regardless of where you are in the US.
He was from that area and told me that ranchers will let their cattle graze where ever they want, even on protected federal land, polluting pretty much every water source and everything downstream. They were very right. We saw cattle feces everywhere. It was very unsettling.
Edit: I also got giardia at Smith Rock one time and it wasn't fucking pleasant.