The surface is a great product, and as others have said here, it's got a lot of 'computer like' functionality. As someone who does a lot of work with photography, you're going to want software that's going to help you work with those pictures. With a Surface RT, you've got your USB port - so getting your photos on to the screen to see what you've got is easy. When it comes to software to work with those pictures, well, with Surface RT you're limited to what's available in the app store, and admittedly, the selection isn't great yet (it's growing every day however).
If you want full blown desktop software, then wait a few weeks more for the Surface Pro - that way you'll have the option to install any software you want, including Photoshop etc. You'll also get a higher resolution display, and the USB port will be USB 3. All of this might be more appealing to you as a photographer, and the form factor is only slightly thicker and heavier than the Surface RT. Beware though, Microsoft have warned the battery life won't be anywhere near that of the Surface RT.
Alternatively, whilst we here at the Surface-Forums obviously are pro-Surface, I'm sure we're all fairly pragmatic too (I'd like to think!) so don't be shy about looking at some of the other vendors Windows 8 Tablet offerings. One of the reasons why the Surface Pro has such poor battery life compared to RT, is that it's using an Intel i5, which is not really optimised for a tablet. Some of the other Windows 8 Tablets from other vendors featuring Intel's latest 'Clover Trail' Atom CPU offer ARM-like power efficiency, but with full software compatibility still available.
Shop around, and now that Surface's are available in stores (not sure where you live, but in the US, Staples and Best Buy, in the UK, John Lewis), you might want to try before you buy