Resolution of the videos should be OK, a lot also depends on the bitrate. there is a thread somewhere on here "video can be better than expected" or similar. find it and read it. I watch quite a bit on my N800 and N810, and find it fine for a portable device.

For OO, again search for easy debian.

And as an alternative to VB, people seem to do a lot with python on these tablets.

A lot of the strength of the tablets, is not that they are really really good at one or two things, but rather the sheer variety of what they do well.