Piggybacking on this a bit: does anyone have a good recommendation for learning more about home water distillers and RO systems? Both for just certain faucets and maybe even the whole household? I know filtering all the water at home is likely overkill (in most places!), but I'm curious.

Under sink RO is not a big deal, you can buy a system for relatively cheap at Sams or probably Costco, and there's not much that you have to know, just change the prefilters when you are supposed to. Depending on the bladder and how much usage the RO system gets, it can take a while to fill a glass, 15-20s maybe? Filling a pot of water is infuriatingly slow.

RO systems waste water as that is how they work, expect your water usage to go up (how much depends on a lot of factors, for us it did not impact our water bill).

Whole house RO systems are probably a non-starter, keeping the water pressure up high enough seems like it would be very expensive.