I have only used it for very bad thatch conditions. As noted, it's a very intense verticut, and intended to get a lot more sand into the profile than you can get with core aerification.
It will absolutely mess up your greens in the short term, but we had a great experience in the long term. It seems a little late in the year to be doing it, but I am not an expert.