One day after allowing New Orleans center Anthony Davis to score 59 points with 20 rebounds, the Pistons beat the Eastern Conference's top team for the second time this season.
Andre Drummond added 15 rebounds for the Pistons, who let an 18-point lead in the fourth quarter dwindle to six before putting away the Cavs.
Tobias Harris, acquired from Orlando in a trade last week, scored 14 in his first start for the Pistons.
Detroit opened the fourth quarter with a 13-2 run to take an 18-point lead on Caldwell-Pope's short jumper with 6:31 remaining.
After going through the motions most of the night, the Cavs finally awakened and reeled off 10 straight points to get to 88-82. But Jackson responded by dropping a floater in the lane, and Caldwell-Pope made the game's biggest play, stripping a driving James and then taking the ball the length of the floor for a layup, a bucket that brought Pistons radio commentator Rick Mahorn -- one of Detroit's original Bad Boys -- out of his seat.
Before the game, the Pistons rescinded their three-team trade last week with Houston and Philadelphia because not all the players involved were cleared medically.
Down by 17 in the third quarter and playing with little intensity at either end, the Cavs clamped down on defense and held Detroit scoreless over the final 4:56 of the period.
However, they were only able to score seven points themselves and went into the fourth behind 75-68.
Harris and Jackson then opened the quarter with 3-pointers, and the young Pistons held it together down the stretch for one of their biggest wins this season.
The Cavs were their own worst enemies in the first half, committing 12 turnovers that the Pistons converted into 16 points, enabling Detroit to open a 56-49 halftime lead.
Download the Cleveland 19 News app.