Because I'm now a consultant, I'm in the habit of doing initial client meetings/cold call meetings in coffee shops. I always buy. And I always use a non-Starbucks. I don't particularly care for the coffee at the stores, and the atmosphere has never really done anything for me.
My two favorite locations in Pittsburgh as of yet for client meetings/general consumption of coffee:
http://www.commonplacecoffee.com/
and
http://espressoamano.com/
Great coffee, nice folk (the Espresso guy always filled my water bottles for free when I was out on my long runs!).
For drinking at home, I go to
http://www.prestogeorge.com/ and buy the JP Hearty blend. The best coffee, ever. Hands down. In a french press, please!