Edited to add: our household does this. we live in a rented townhouse, so we're unable to add our own plumbing or electrical stuff. Yes, it's an expense to buy our own drinking/cooking water, but we just don't trust city water. If you live in a nice area with a diligent water authority, that's fine, but those types of places are a vanishing minority in the USA nowadays.
I've never heard of other issues with the water quality in Charleston (assuming it's city water and not straight from the Kanawha), and I consider it some of the better-tasting municipal water in the Mid-Atlantic region.
But a quick check of boil water orders (i.e. bacterial infestations) suggests that Massachusetts needs five or six a year, and West Virginia needs five or six a week. That could be sampling bias.