maybe it's time to find out.
(for the record, i tend to agree with you. charismatic is not my worship style, but done right, it must have many good characteristics for the people to whom it appeals. otherwise three pontiffs wouldn't have praised it.)
I just looked some things up along this line:
From what I can see, Pope Paul VI never "embraced" the Catholic Charismatic Renewal, but rather said about some charismatic conference that it was a "chance" or "opportunity" for the Church. That's pretty vague.
Pope John Paul II made some comments about the Catholic Charismatic Renewal in 1998, but didn't go so far as to embrace it that I can see. Rather, it seems, that he saw some benefit being possibly derived from the movement by the Church and stated his hopes for the future in that regard from what he's quoted as saying. He promotes the obedient acceptance of charisms, but does not promote the "charismatic movement."
And...regarding Pope Benedict XVI, it seems that people are trying to retro-actively apply Papal authority to statements he made from the office of Cardinal as Joseph Cardinal Ratzinger. I did not find a single statement actually embracing the Catholic Charismatic Renewal coming from him after he ascended to the Papacy. That said, I did find some statements which, from the Pope, seem to be encouraging regarding specific points which are valued by the Catholic Charismatic Renewal, though certainly not exclusive to it.
I don't doubt there are good points or characteristics which are found in the Catholic Charismatic Renewal, but I think from what I've experienced in it, there's not much good about it.