People have been using paper as a content creation medium for millennia; there clearly isn't anything inherently anti-creation about the tablet form factor. Tablets are only bad for content creation if you consider 'content creation' to mean traditional creative computer software. Photoshop CS5 would be terrible on an iPad, yes, but that doesn't preclude the future existence of equally deep and compelling tablet image editing software (for example).
I class things like "writing an email" as content creation too, and it doesn't look like a pleasant experience on a tablet. You could write a sentence using one hand whilst holding it in the other, but if you want to write a paragraph or two, you really need to put it down on a surface and then hunch over the device to type down on it. I say "hunch", because the screen is flat rather than at an angle when you place it on a surface, unlike a laptop.
I'm not considering the fact that you can plug a tablet into a hardware keyboard because if I had a tablet I certainly wouldn't want to carry a keyboard round with me just in case.
I'd rather just carry my laptop around for content creation, and use a combination of my laptop and mobile phone for content consumption.
I really hope somebody comes up with an innovative solution to add a hardware keyboard to a tablet. Something along the lines of a very thin hidden internal keyboard which you can pull out of the bottom, and then bend to an angle so you can place it flat on a surface with the screen angled towards you. I'd barely need a laptop anymore then.