Despite its glaring flaws, the Surface Pro really isn't a bad device. It can handle applications and multimedia as well as any other ultrabook. It doesn't fall short so much because it's a bad idea as much as it just wasn't properly executed. It needs to be more in sync with Windows 8.
Ironically, the Surface Pro might be best used as a device for the home. You can dock it to a keyboard, mouse, and monitor, where it essentially functions as a brain. And it would be fine as a living room/bedroom tablet, where weight and portability are less of a concern.
But if you need a primary Windows 8 machine that you can take anywhere, use anywhere, and really get stuff done, the latest generation of ultrabooks are still your best bet. For now, the Surface Pro is a work in progress.