Best Coconut Water?

Let me preface this question by saying that initially I am not a HUGE fan of coconut, however, I've read so many things about the benefits of coconut (oil, water, etc.) that I started introducing coconut into my life, slowly. I need something more than just water sometimes. I drink iced green tea, but I digress. Also, I had coconut water from the actual coconut itself and it was pretty good.

Recently, my boyfriend's sister told us to get Goya Coconut Water. She says its what she uses in her routine, (competitive Judo & training) Well, I took a sip and almost threw up. It is so sweet, the pulp is gross and the SMELLLLLLLLL is horrendous.

I know there are lots of coconut waters on the market. The question is which one is the best kind? Like that the one that isn't artificial and processed, but economical so I don't have to buy 20 coconuts a week. I know everyone's tastes are different, but there are clearly "good" drinks and "bad" drinks. I qualify GOYA as the bad one, so I need one that is the opposite of that.

Any suggestions would be awesome! Thanks!