The first episode of Showtime's "The Big C," where Stamford stands in for Minneapolis, is now available online. You can watch it on YouTube or IMDb.
The only local spot I recognized was this one, when Cathy Jamison (played by Laura Linney) dines at Saltwater Grille, with Harbor Plaza in the background.
If Stamford Harbor is supposed to be one of Minnesota's 1000 lakes, shouldn't it be frozen year-round?
Here are a few views of Cathy's house on the show:
It looks like a nice little Shippan-type house, but I'm not sure where it is (and I'm not about to go stalking the nice people down there to find it).
As for the show itself, I didn't really care for it. Cathy is a high-strung, risk-averse cross between Ed Norton's character in Fight Club and Ben Stiller's character in Along Came Polly, and she's not particularly likable or sympathetic, even after you learn she has cancer. Her annoyance with her estranged husband seems forced, as if the writers felt the need to throw one more complication into her life, so they said "Let's have her kick her husband out for no reason!" Her relationship with her son is also oddly annoying. It's like they tried to take Weeds and replace a 40-something mom dealing pot in the suburbs with a 40-something mom dealing with cancer in the suburbs, but they forgot to make the characters interesting.
Anyway, that's just my take. Check out the show and see if you can spot any other hometown localities!