I'm not a coffee snob, but I may be a coffeeshop snob. And for that, Upper Espresso gets my full approval:
Doesn't play the music too loud, supplies power strips so everyone can Facebook as much as they want, always bright and clean, pleasant employees, and Wednesdays is $2-any-size-lattes! The baked goods aren't anything special, but can still satisfy for a reasonable price...yum.