Of all the LBS I've come across, I can say that only two are GREAT.
One is an MTB specific shop and the other is a RB specific shop.
Both are completely different. One's small, the other huge.
But both offer the same thing: Great service.

I go out of my way to support them (literally...one hour away).

I bought my most recent bike from an LBS and here are some of the things I experienced:

Shop owner (while looking at me):
"You're 5'9"? Why are you riding a size 56cm? Do you have short legs?"

How they "fit" a tourist renting a bike (owner yells to one of the mechs in the back):
"John Doe, I need you to hold the bike so we can fit her to it."

Not to mention that I was told my bike would be ready and when I went to pick it up,
the owner told me that when he talked to me earlier that week, I told him I'd call him Friday.
Um...I called The Shop that Saturday morning. I hadn't spoken to the owner in 2 weeks.
Then, he tried the old Jedi Mind Trick. "Don't you remember? When we talked Monday?"

I swear, if my girlfriend wasn't right next to me, I would've completely humiliated
this mutt in front of all his customers and made the biggest scene, but...I digressed.

So, I told them to bring my bike "in the box" and I took it to the LBS down the street and PAID them to assemble it.
They had it together in 1 hour (even though they were very busy) and they did a GREAT job.

Guess who's getting my business from now on?