It all depends on the make up of your team. Any manager who said they wised they didn't have to have the guy who's leading this team in BA, HRs and RBIs in the lineup every day would haven to be complete fool. Of course, in this case it was never actually said, as we know, if we know beanie.
But let me ask you something. If Cano were a horrible fielder, would you want to take him out of the Yankee lineup and get rid of him, or would you rather keep him there as a DH? Would the Yankee offense be better with him gone, some much lesser hitter playing 2nd, and the Yankees then rotating around the DH, or with Cano being the DH every day? There is no set answer for this for every team, it depends on the players on the team. Anyone who thinks the RS would have been a better team over the last decade with them rotating the DH around among the regulars rather than having Ortiz as the permanent DH better take a look at the stats they would have had to replace in their offense first.