Grant's has a great selection of cigars, cigarettes, and pipe tobacco. Even if they don't have the exact thing you're looking for, they will have something similar that will satisfy you. If you can't find tobacco to smoke in this shop that you like, then you're too damn picky. The "lounge" area is a great place to hang out and enjoy a smoke and converse with the crowd or just watch the scene on Market Street.
Pros: excellent selection of tobacco products
Cons: they're not open 24 hours a day