The closer you are to a major metro market, the less likely (not zero) you will be able to find knowledgeable, experienced staff that can provide advice based upon their years of experience on the slopes and in the shop. The closer you are to a resort, your odds increase exponentially.
My experience was always that they had a script they followed, a formula, a couple choices for each "category" and that was the end of it. Everything had a formula. The only thing I ever bought from Ski Market was a pair of ski racks.
The shops near the mountains are run by guys and gals who are out every day, who had skied/boarded on nearly every piece of gear in the shop and every possible condition. They go to the shows, race, slack, sit in the lodge, mix and match equipment, do repairs, see what people damage and how and so on: experience. It shows in the selection of gear they stock. They really get to know your skiing style, abilities, the slopes you run, and your objectives, before they start pulling out boards, boots and other gear. Yeah, it may cost a little more, but in the long run, it's a much superior experience.
Sure, there are exceptions. A few great folks can be found in the metro areas, and a few bad apples are in the resort towns. I'll go where the best odds are of good advice and service.