Offensively, Tate is a career 30% 3pt shooter, but despite that, he is capable of putting up points on offense by backing down smaller players, cutting to the basket, and running in transition.
I don't consider him an offensive liability because he does have the ability to attack closeouts and keep the ball moving. Also, in a better situation than the Rockets, where the players don't compete for shots and instead influence ball movement, Tate would seamlessly fit off-ball on a team with an elite creator.
He isn't a franchise-shifting player like Damian Lillard, but if you are a playoff team with championship aspirations, Tate can be the last piece of your rotation that can sway tightly contested playoff games. My reasoning as to why he will be the best acquisition is that the teams that would most likely trade for Tate will be a team in contention, and Tate's skillset will pay dividends immediately. On a minimum rookie deal with a team option, Tate is the definition of low risk. If you're a team like the Jazz or the Nets, where you need defensive depth against wings if you want to make a deep run, Tate is capable of providing 15-25 healthy minutes against the Derozans and the Bookers of the world. In terms of value, I doubt acquiring Tate would cost more than a future protected first or a few 2nd rock picks. Maybe even a swap of backed end young prospects.
I'm aware he might not actually get traded, which... I guess to make this far-fetched take even more far-fetched. Any playoff team could acquire Tate, and it would be considered a good move. He's that type of player. If I were the Nets, Jazz, or the Clippers, I would seriously consider trading a low future pick and maybe a young prospect to obtain a high energy, defensive difference-maker. Tate is one of my favorite players to watch. Will he change the course of your franchise like Ben Simmons or Domantas Sabonis? Probably not. But can he be the last piece of the rotation of a championship team, hell yea.