As far as Bruen being a failure because some liberal states have enacted retaliatory legislation, I disagree. The OP seems to be upset with Bruen because NY, DC, and liberal states and courts are purposely misinterpreting and circumventing their ruling. That's not a fault of the ruling but rather those states and judges who choose to ignore it.
If I see any fault with SCOTUS and their Heller, Mcdonald, and Bruen decisions, it's not with the decisions itself, but rather their unwillingness to enforce it and make lower courts abide by it via large fines, emergency stays, and contempt of court. Any laws are effectively mooted without enforcement or repercussions for breaking them. The same is true for SCOTUS rulings.