I sometimes work on the SP, but only on a desk connected to a second monitor and mouse. There it's basically just like a desktop tower.
http://www.dangrossman.info/2013/07/14/summer-workspace/
On its own, the kickstand and not-quite-rigid keyboards make it a pretty subpar laptop for actually coding on a lap.
I have it mostly so I can throw it in my car whenever I leave and know that if a server goes down, or some other issue comes up, I can handle it wherever I am -- it's a full computer but more portable than a laptop. I don't feel the need to carry a backpack or big bag to haul it around in, and I get ~5.5 hours of battery writing code so I don't carry the cord either.