Interesting question. One store in Vancouver is fully stocked with all sorts of dive gear(or was the last time I was in it), lots of choice in rec gear well laid out and very attractive and I wouldn't spend a dime in the store. Unexco in Freeport is similar. Great store, lots of pictures lots of stock - but their market as is the one I am thinking of in Vancouver, is the new diver. Full retail prices, no, or minimal stock on anything but beginner gear and impulse buy high profit stuff. Backplate, webbing, bolt snaps, paddle fins ... not going to find them here.
The store I frequent here in Victoria is small, and not a lot of stock, but so far I have not come in and asked for something they didn't have. Same for the couple in Vancouver I frequent. All have local trips for a whole range of divers from beginners to tec. Victoria store had an ice diving trip some time this month for example. All have a weekly guided dive - just show up to the shop.
I do want a store that is at least neat with a professional appearance, I want to be able to see the compressor or at least have access to it and I want to be able to BS about my latest trip or the shop's latest trip, or upcoming event, for a few minutes when I drop in. Wouldn't deal with one that was as much of a disaster as my basement, but don't need/want much more than neat and tidy. If it is full on retail I will probably move on.