The answer here is slightly complex.
Yes, in general, a framesync TBC from Cypress or DataVideo will remove Macrovision. In general. And it's the best way, often the only way.
But it helps to understand what Macrovision is, so you know why it can fail at times. MV is essentially an artificial video error injected into a tape signal. And it can vary from tape to tape. Sometimes video errors can overrun even the best TBCs, and can have various failings or byproducts/artifacts post-TBC. Not just title to title (example: Mortal Kombat), but even copy to copy of the same title. One MK tape may pose problems, while another MK tape is flawless post-TBC. For example, my own MK tape has zero errors post-TBC. But I have a The Tick animated tape that balks at all TBCs, and a Young Indiana Jones tape that balks as well. I have a 2nd copy of the Young Indy tape, and it's flawless post-TBC. Since I have The Tick on DVD, I've never bothered to get another VHS copy, though I doubt it's title-wide problem (just the copy).
So it's not 100% foolproof, but probably 90-99% range.
Those "Macrovision removers" (clarifiers, scrubbers, etc, all euphemisms) are more like 50% at best, and even most of those "successes" will have color/brightness issues. Something like the Grex is a complete POS, though it ironically does work well to strip cable box MV, allowing MV-abiding recorders like Philips 3575 to make dubbable recordings from channels like HBO and Fox Sports.
Cypress and DataVideo can act differently on signals, and that includes MV. It can be helpful to have both kinds of TBCs, if you rely heavily on performing TBC-needy tasks.
The only caveat with the AVT-8710 is that it needs to be green, not black, and in known-good condition. Even the DataVideo needs to be in known-good condition. Never trust the eBay
idea of "tested" and "works", as the bar for those statements is generally low, if not just an outright lie.