Most Costco's out here are the same story in terms of lighting (all LED, some dead highbays here and there. nothing noteworthy). Except for two stores, the Sunnyvale store, and the Santa Clara store.
The Sunnyvale one is the best-looking one i've seen, while it is all LED, they do a good job keeping the lights in good shape and repairing/replacing LEDs when they fail.
The Santa Clara one OTOH is the worst when it comes to keeping their lighting in good shape. In the store, at least 1/3 of the LED highbays are dead or dying and about 5 or 6 of them have been hit by forklifts. They have also done things like
this for example...