AMD CCC does not allow the most dangerous overclocking possible, at most you're going to crash and then you turn it down. Power limit increases the amount of power draw allowed to the card, it allows higher clock rates/stability.
I have yet to ruin a card by turning CCC to max, i've gotten flickering issues with dual monitors (old drivers on old cards), but no stability problems.