I went into this thinking that Costco and Sam's Club would be clear winners across every product category. Here's why I was wrong.