Yea. It does deliver such performance. Just get more light. Any camera, even that 50$ drugstore digital camera can look like a professional grade camera. All you need is the skill and knowledge, and go far on top on the mountains above the clouds, on a very sunny day (exaggeration). Every camera manufacture do that. This is why the real test, is low light situation, which they rarely show, as it nearly always looks like crap. Nokia is the only phone manufacture that showcase their camera under low light as it uses this massively large light sensor, and complex image stabilization system. Making the camera pricy for the specs, as the camera cost a lot. This is also part of the reason why DSLR cameras are pricy. Beside the lens which does play a big part, the sensor size it costly. But sadly, in the digital camera world, even cellphones it's all about Mega pixels, and nothing else, but that is a different topic.
The Surface Pro 2 camera is on par with most ultrabooks at release.. well announcement, to be exact. Just now, manufactures started to put better ones (which doesn't say much either).
If you are doing real work, then you should definitely use a DSLR camera for professional looking results. Not a cellphone or any tablet.