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.

Costco. The Charmin they sell is 1/2" wider than what’s available elsewhere. It makes a difference.