I tried zeosand, a pool filter sand variety of zeolite, in a 10 gallon tank. I didn't see either an advantage to it or a disadvantage. What I did see was a very unattractive color, a dull greenish color. As far as I could find out with a google search, there are only 3 or maybe 4 different zeolite pool filter sands available, and only one is a tan or beige color that could look good in an aquarium. The others are ugly, in my opinion.
High CEC is theoretically a big advantage for growing plants. But, I have yet to see any data that puts a percentage on how much better it is than low CEC. I think if you have a choice between high and low CEC, and you don't otherwise prefer one over the other, the high CEC sand is the way to go.