That may be true, but let me play devil's advocate.
CV is a guy who has played on garbage teams his whole career. The BEST team he's played on was last year's Bucks team and they were 34-48 and last place in their division. By going to Detroit, he'd be going to a team past its prime, coming off a sub .500 year without a head coach even in place. The money may be a little bigger in Detroit but if he has any sense, he'll realize Cleveland is the opportunity of a lifetime - slotting in at the 4 between the best player in the NBA and an all-time great on one of the NBA's best teams. Take less money now, wait 3 years and get the big payoff when he's 28 years old, in his prime, with (hopefully) some rings under his belt.
For someone who has to be sick of losing at this point, to go to a team that is destined to finish below the other team interested in him would be pretty foolish unless he just wants to get paid... but if that's the case, I don't want him here in the first place. Hopefully we have some good advocates in Mo and LeBron who can use their connections to get him to make his decision from a competitive standpoint.