I just got my second one in the mail this weekend. We use them pretty much like most people would use a laptop (and then some).
I hate laptops, have to work with them every day. Compared to any nice desktop they ain't good at anything. They are a major pain in the butt, in fact. So, in our house there are no laptops, but there will be even more iPads (or comparable devices).
Unfortunately, there won't be any competition from MS or HP in the near future, but I hear about Android based devices might be coming out.
Today, I found the Captain's Log app - it has an LCARS interface.