With a web browser, the sky's the limit on content - specialized or otherwise. But no one should expect to edit HD video, write a novel, or conduct intense computing tasks on an iSlate...
Maybe not on-the-go, but if you can dock it and get a keyboard, mouse, and large screen then certainly you could do all that. That's what I'm hoping for - a tablet with a touchscreen keyboard for on-the-go, and a dock to get all the goodies when you're at a desk.