I have 3 Cabelas and a BassPro store within 90 minutes of me. A new Cabelas just went up last year and went shortly after they opened. I was looking at some flies and a lady come over. I was looking for larger streamers for Atlantics. She just came back from the same area, sent me photos of flies that worked and then called her friend who was still fishing the area. Great experience. The main guy who heads up the fly section at BassPro is pretty good also. BassPro here seems better at fishing and Cabelas at hunting.
When I was growing up, the best place to go is now geared towards Walleye fishing, which I can't blame them. Had a shop within 7 miles of me which I won't do business with again. Local stores definitely have a leg up on conditions and latest hatches.
So far, I've seen the union has been great. When I was at the Cabela's store, bought a fly reel using BassPro store credit. I don't have the same luck all the time and find if you go during the week daytime, the folks tend to more knowledgeable.
The Orvis store by me is more about clothing though do have good selection of fly equipment. Unfortunately, my last visit there wasn't all that pleasant. As I was buying my flies, they moved me off to the side where there was no counter so a gentleman could buy his collection of vest sweaters and other clothing. Nice guy and folks operating, but handing my change in the middle of women's clothing racks.