I've had a mostly good experience with the local indy-owned NAPA. They adhere to the national ads, and promos, albeit with a bit of reluctance, so that can result in some deals that the other chains stores can't match, and on some stuff the others don't carry.
The issues that can arise are the result of the separation between the corporate operation, and the store being its own entity. Sometimes they don't connect.
That's best avoided by being aware of where the pricing or promo originates from, and using that channel to pursue the transaction. The national/website-based promos also have their share of exclusions, and the site can be a bit wonky, but they're far from unique in those respects.
With indy stores vanishing, I'd hate to have to rely on one of the big chains, even for ubiquitous, generic stuff, so it's good to have NAPA around as another option, even if they straddle that divide uncomfortably sometimes. Come across an old parts vet who knows their stuff, and knows how to cater to pros with no wiggle room, and they can save your butt, even as a DIY.