You raise wise and excellent questions!
In short, no. My desires were not readily met with things available locally. My need was not for a particular product or model, but for a product from a reasonably general category of things with a couple of attributes. There are a variety of products available in the broader market that would have done it for me, only some of which I was aware of. Talking to an array of local small business owners got me a circular set of pointers to other shops to try.
In your example, imagine going to local hardware stores and finding that none had anything that would meet your needs. They'll happily sell you a selection of hoses and send you to another hardware store that has a fine selection of wrenches, but nothing helpful in meeting your needs.
And I’m in a major metro area.
When I lived in the sticks? It was more 25% solid, 75% crap.
For instance I could spend hours reading reviews about power washers and finding the perfect model and then lamenting it not being available at my local hardware store. Or I could just buy whatever corresponding product they have and be just as happy.