I too remember seeing brown water coming out of the faucet on my first Mariner cruise. I was filling up the tub so it was OK, but several nights I got up and just drank some water, kind of creepy when I think about it now.
Nothing could be worse than one night in Arizona, I got up filled my bathroom cup with water and it was crunchy. A cricket...EWWWW. I always rinse out my cup now before drinking from it.