Adding to the Ohio list of good gaming stores (on top of warzone):
Ever since I was 10 years old I had been frequenting Mr. Cards & Comics on the east side of Cleveland, OH. The owner is a friendly guy, and a shrewd businessman. The store is positively tiny, but he manages to pack as many magic-bearing tables into the tiny store as possible. Rather than pushing pure MSRP for magic packs onto anyone who walked in, the owner would often cut your price down to "box level" for as little as 5-10 packs bought at once. If he knew you for a long time, you could get that deal at 2 packs. He also was an expert at finding 8 people and talking them into a draft. Obviously it was in his interest to do so since he'd make a buck, but he helps a lot of shy, unsociable nerds organize themselves and group up with strangers.
A more recent discovery of mine is
Underhill's Games in cuyahoga falls, Ohio. Their bread and butter is the top 40 off of boardgamegeek.com, but they also dutifully support pathfinder and 4e, as well as carrying most of the major or new collectible franchises (WoW TCG, Magic, Monsterpocalypse, etc.). They have been my outlet for all of the D&D gameday events i've attended, they're starting to host LFR RPGA days more often, and people organizing local cons often come to advertise the existing of their cons. I'd never been to a con before frequenting that game store because they all seemed so far away and intimidating, but this has since changed. Interestingly that's not even the store's main thrust. They host a few different boardgaming events, bimonthly, and at some events food is provided along with demos of brand-spanking new games (that day has a small fee, but if you try out enough games you get part of your fee back in store credit.)
Speaking of demos and store credit: Underhill's handles both quite intelligently. No matter what day you come in, they have a pile of store-copy boardgames available to try out if you're curious about buying. And when you do buy, any purchase over 25$ (and what boardgame or RPG book isn't?) you get 10% in store credit. This isn't some piddly coupon though, their store credit are delightful wooden poker chips, custom made with the underhill log on them. They have shrewdly predicted that i am often conflicted between cashing in and building a larger pile of specialty coins for me to stack and un-stack.