I've got a surface pro 2 (256gb version) that I have the CS6 running on. Its fantastic, I can run Photoshop and Illustrator together and not have issues with performance. I haven't used them for huge files (mainly editing photos for web use/creating logos) but I think it would handle it. They can get pricey for the new SP3 but I would say that it is worth it. I would like to upgrade but there is nothing wrong with my SP2 so I'm going to wait it out.
Hope this helps in your decision.
Chaz