Even assuming you're right about the cause, the success story of sanctions would be a South African economy that never recovered leading to the suffering of millions. That's what happens when they "work."
If on the other hand the population is already angry at the regime, maybe it has the desired effect.
Idle musing without supporting evidence.
Edit: But to be clear, I think the US sanctions on Cuba are gratuitous and cruel. Cuba is not some rogue state and there are many worse dictatorships that aren't sanctioned. However, I think it reinforces the point that "sanctions can be devastatingly effective applied by a significant majority of the world" because in the Cuba case the rest of the world didn't agree.
There were considerable limits (particularly on foreign investment in Cuba) because parts of the US sanctions regime include retaliatory sanctions on entities making use of certain property in Cuba (some of these were suspended for a while, but restored under Trump in 2017.)
Unfortunately talking only about sanctions ignores that plenty of governments resisted and watered down the sanctions because the apartheid regime's anti-communist ideology.
The negotiations to phase out apartheid for a democracy began mere months after the fall of the Berlin wall. At that point the collapse of the USSR was imminent, and the apartheid regime's utility as an anti-Communist outpost had expired.
Yes, in some fairytale world the ruling National Party could have continued "doing whatever they want". Here in reality things would certainly have got worse, and the National Party government could see that the end-game was inescapable. Sanctions worked then, and they'll work again.