Depends on where the water comes from. Even across just Colorado, there's a range of taste and 'texture' to the waters, depending on where they draw the source from. Some are very crisp, little taste at all, no smell, while others are faintly musty and have a bit of a slippery texture to them. Some are metallic, others, mildly earthy.
Slightly mineralized water is actually quite good, especially the water that draws up from my folks' well. It took some getting used to when I first started drinking it again after being in the metro area, it was a little 'thicker' than I expected from water, and before they upgraded the conditioning system there was a faint sulfurous smell to it that was mildly off-putting. Without that now, though, I find it a very tasty water. It also draws very cold, and is refreshing right out of the faucet.
The water here in town where I am now is not quite as good, and doesn't draw as cold as their water does. Without ice, it's only tolerable. Also, I filter it, now, because I can't get past the taste of the treatments they add to it. It's also a little slippery, and sticks around for a few seconds after you finish drinking it.
But, I do love cold water. Bottled waters are largely a sham, unless you're drinking something that's clearly indicated as from a private spring, you're simply drinking filtered tap water, anyway.
