Most of the articles focus on Russia at the moment, but here are a few I've seen.

• NPR article on why sanctions don't work, with a bit of copium thrown in https://www.npr.org/sections/money/2023/04/11/1169072190/why-sanctions-dont-work-but-could-if-done-right (https://archive.ph/HPJIf)
• one from the economist https://www.spectator.co.uk/article/why-the-economic-war-against-russia-has-failed/ (https://archive.ph/DCpgR)
• The Guardian admits sanctions on Russia failed https://www.theguardian.com/business/2023/may/21/the-west-tightening-russian-sanctions-a-sign-of-failure (https://archive.ph/7HRMC)
• Asia Times explains why western sanctions are based on flawed premises https://asiatimes.com/2023/06/the-false-and-failed-logic-of-western-sanctions/ (https://archive.ph/Debo6)
• there's also an actual paper explaining why economic sanctions don't work https://www.jstor.org/stable/2539368