Does my Costco membership affect my right to sue?

No. South Carolina courts do not enforce membership agreement provisions that attempt to limit liability for negligence. Your membership affects warehouse access, not your legal rights.