Using modern filters, and using a pressure booster pump to ensure proper pressure level this is actually nowhere near as bad it’s now possible to achieve a one-to-one clean to waste ratio.
If you don’t want any waste you can go to nanofiltration which is roughly as effective as Reverseosmosis and does not have the Wastewater issue but they are significantly more expensive.
And it’s not as if that Wastewater is sewage it’s just the same water that came in with a higher concentration of the stuff that you didn’t want that was already present in the water so that Wastewater can be reused for gardening, or gray water such as showers and toilets
I get that they aren’t perfect but everything has a trade off and reverse osmosis or nanofiltration is really the only way to get rid of many different sources of water contamination especially things like microplastics and pfas
pacman is the best and I’ll stubbornly refuse to entertain any other opinion. It’s in my experience the least likely to just randomly rip the system to shreds. I don’t know if it has more through prechecks or what bit I’ve had debian and Fedora (apt and dnf) rip the system asunder trying to jump multiple major versions in an update of a system that hadn’t been online in a long time.
I don’t care if jumping multiple releases at once “isn’t supported” it shouldn’t be that frail and arch will happily update something many years behind as long as you update the keyring.
Even in the event your system somehow does get hosed you can fix almost everything by just chrooting in, grabbing the static pacman binary, and running “pacman -Qqn | pacman -S -” I’ve recovered systems that had the entire /bin wiped (lol oops moment with a script) and as far as i know apt and dnf have no equivalent easy redo all.