Sanctions are a slow economic weapon, one that's only half of the current economic strategy (the other half being asset seizure and uncoupling of Russia's financial sector from global finance).

It's hard to say whether any given sanction is "worth it." But the long term trend is a politically advantageous one for NATO: oligarchs now need to keep all of their money within Russia's borders, where it's both unstable and subject to court whims. That should worry them, and the hope is that it worries them enough to unmoor them from Putin.