Why is it impossible to use by itself? You can browse the internet, you can buy media off of iTunes, you can edit documents, and you can send email.
The point is that the iPad is sufficient for the average user, but it prevents the graduation to power user by poking around and learning how things work. I very much doubt self-hosted development will ever be made available.