Highlighted in red is cade's biggest weakness when it comes to scoring, he straight up needs to score better than 59% at the rim to reach the next level. He's never going to be the best athlete in terms of speed or strength, but he has good size for a PG/SG whichever you want to classify him as. If he can get his scoring at the rim to be around 65% he'll make a big leap.
In yellow are causes for concern but not necessarily a weakness. He did not shoot well from 16 feet - 3Pt range and it obviously needs improvement. However, even when Cade was struggling early in the season I was one of the non Piston fans who weren't overly concerned here. Cade's college numbers indicate that he'll be a good three point shooter at the least as he's indicated he's has range in the past.
I don't know if Cade we'll become good-great at long 2s though as even players like Tatum can struggle here. Cade's strength (which i''ll get to in a bit indicate he might grow in this area), but time will tell.
In green is where he shies at, for a rookie, Cade is excellent from 3-16 feet at 43%. I do not see why he can't improve in this area and become a mid range assassin.
The ultimate version of Cade shooting is probably something like 25+ points on
(65% 0-3 ft/47% 3-10ft /45% 10-16ft /40% 10-16ft / 37% 3P)
if you want to give him higher shooting percentages in the mid range I can see that happening.
While I don't think he's going to be uber elite at getting to them rim or three point shooting like say Jalen Green might be, his overall scoring game compared to Green's is much less exploitable, especially in the playoffs.

For comparison's sake here's Jalen's shooting stats.

While Jalen is much better at getting to the rim and is the better 3 point shooter thus far, quite like Harden. However, green has a major weakness in his scoring that cade just doesn't. Green is legitimately bad from 3 ft- 16 feet and I have more questions about Green in the playoffs than I do with Cade simply because of size and Game. If Jalen's 3 point shot is not falling he's going to really struggle in the playoffs as he just lacks size to get easy shots.
This is quite the polar opposite of Cade who pretty much relies of guile and size for scoring instead of sheer athleticism with green
Long term I also question Green's longevity when his athleticism fades, Cade's game will most likely age well.