Is it generally better to buy Charmin Ultra Soft toilet paper from Costco or Sam's Club?

Which warehouse club?

Neither. Get a bidet and your TP costs will drop to next to nothing.