Some games prefer cache (CCD0), while others prefer frequency (CCD1). However, having both CCDs enabled is also important in some cases.
I'll give you an example. I have a 7900X3D, and a triple-monitor setup. When I play MSFS which absolutely loves cache, the scheduler parks CCD1. Which is great, I get amazing FPS.
I tried disabling CCD1 in the BIOS just for fun to see if I would get better performance in MSFS, but nope performance was the same, but it got worse when I clicked anything on another monitor. Performance in game would start to stutter and lag, and the whole system would feel slow.
The reason this doesn't happen when both CCDs are enabled is because while the scheduler would park CCD1 when playing a game, it would wake it up when I click outside the game, so MSFS would still get all the performance of CCD0, while CCD1 allows me to do other things outside the game at the same time without the entire system slowing to a crawl.