I love The Spyhouse, I go there often since I have friends that live nearby. They have a hipster-y feel to the place, the baristas play what music they want and it's always great tunes.
They have all the usual coffeeshop drinks plus a few notable drinks that only they make. I recommend The Spygirl (Coldpress, Espresso mixed with a vanilla shot), several flavors of milkshakes, and the Tokyo Rose (not sure what's in it, but it's delicious). And try the Hummus! It's great!
They have a counter full of different events happening around town which is always worth a look.
There are usually several art students in there being that it is so close to the Minneapolis College of Art and Design (MCAD). Mostly working on projects or on their computers or relaxing.
If you have a laptop with a wireless card, bring it along and take advantage of the free wi-fi.
I love this coffee shop!