Update:
If you were thinking of getting the iPad 2 just for the cameras-my advice, don't.

Seriously, they are pretty substandard quality-video is barely ok, and oddly, Photobooth looks good, but the still quality is just crap. I doubt people would be taking photos with it anyways, but just as a heads-up, overall really disappointing quality. Really grainy.