FFVII's Weapons are pretty good in durability but their overall offensive capabilities suck.

The damage Saphire was taking was impressive but when it finally attacked with a charged beam of energy, it wasn't anything I'd say that could pierce Sin's barrier.

I'd personally say FFIX Odin could take Saphire and most of the Weapons we saw in FFVII but he couldn't take Sin.