The only kind I've been able to stand drinking is straight out of the coconut.
I've tried a couple of brands, and none really taste anything like that to me. (could be that I was bordering on heat stroke when the fresh coconut water was offered to me, though... I haven't had the chance to try it when I wasn't having issues with temperatures.)
I hated it until I did the Whole30. I'm sure it's because I dropped all sugar sources beyond fruit. But now that I eat paleo, it tastes a TON sweeter. I really like Vita Coco. Yummers.