I don't think I have seen anyone say anything like this on any of these threads so I will say it... The attack was real and thankfully no real harm was done, however despite CCleaner becoming compromised, that does not make the product bad for people to use. Skilled black-hats will intentionally target businesses with a lot of clients so they can make it worth their while (especially for the risk they take if they get caught), so it is not surprising that Piriform was a target considering they had well over 2 million active users across both home and business individuals.
Other vendors have been compromised in the past, even security vendors. Maybe not the same way CCleaner became compromised, but this is the real world where the threat is real. For example, Kaspersky have found an infection internally before (not within their deployed software releases but on their own systems, I think it was 2015 or 2016).
I am sure that Piriform will take more precaution in the future with assessing new software releases before deploying them via an update, and re-assess their security practices to prevent something like this happening again to the best of their ability.
You can use security tools to restrict what operations a program can perform as well, so you could keep using the updated clean version of CCleaner whilst having it under restrictions so it cannot do anything out of the ordinary without a configuration change/user acceptance.