As someone who hasn't owned a tablet, I'm not so well versed on the subject. I think smaller tablets (such as the ipad mini, nexus 7, kindle fire) make great content consumption (nice term :D) devices, but I'm not sure how well larger devices could act content creation devices. Depends on the kind of content I suppose. At least its a nice point on which to differentiate between small/'full size' tablets.
What content do people create on tablets? I can imagine they'd be handy to work whilst travelling, but, working on a tablet with a laptop, desktop or AIO available would seem counter productive IMO.