I seem to be able to taste the difference between water brands and taps more than most people I know. I liked Ozarka spring water (Nestle). Aquafina is one of many purified municipal (tap) waters (PepsiCo). Haven't tried much Smart Water (Coca-Cola), but I do like VitaminWater ZERO (Coca-Cola) as a naturally-sweetened sports drink.
I stopped buying bottled water because it felt kind of ridiculous (esp. all the little plastic bottles). It was very convenient though, and I probably drank more water. I've since bought a Brita pitcher ($15), stainless steel bottle ($15), and buy filters ever 8-12 months ($20 for 4). Tap water here is good (trusted), but very hard and I don't like the taste which means I'll drink less, hence the filter.