Except for video editing, everything I do that matters happens on a server somewhere.

Wait ... I do photo editing locally, too, but I've seen some nice demos of iPad apps for that.