I have the sp2 for a little over a week. iPad has been relegated to the closet. Just received a SSD external drive to hook up to the sp2. Finally I have a tablet that runs all the applications my company has as well as VPN and RDP. Now got see how it works tethered to my DSLRs.
I can see why. Just doing an across the board comparison between an iPad Air, Lenovo Helix and SP 2 the SP 2 seems like the best choice for anyone that also needs a tablet for business. I initially though the Helix was the way to go, but to me there are enough improvements with the SP2 that it's now a bit better choice IMO unless you absolutely need a convertible. I also could care less about "apps" and I don't need a camera on a tablet to do any more than act as a copier. 
The biggest neg for the SP2 is weight. I also couldn't determine what it supports for mobile data. Doesn't seem to support LTE from what I can tell.
If all I needed was a bullet proof web browser, access to email and listen to music or watch videos then the iPad Air would be the way to go ... but then for that I'd just keep using my first gen iPad until it completely dies (battery life for mine is really low now, so it's almost there). The biggest neg for the iPad for me is that I need to take hand written notes during meetings. A capacitive screen is horrible for this purpose where the Helix and Surface Pro 2 support Wacom pressure sensitive pen input. Another negative is that I need to use a Citrix app to run MS Office applications especially to view Excel spreadsheets with graphs. It's pretty awful.

