I haven't watched the video, but I'm pretty sure it's a 21" or 22" Cintiq video tablet. Those things are sweet and would be perfect for use with Sketchbook (or Photoshop). They're ONLY $2000 or so :) Get one and post some cool stuff for us to check out.
I can daydream...:) I'm going to have to remain in drool mode for now. I got an Intuos4 (small) and Sketchbook Pro to get started. I think it's nice that the tablet comes with a variety of software to use. And now that Adobe offers subscriptions to the expensive Creative Suites, I see have have much to learn! (I'm just a beginner, used to drawing on paper).
I have used it in 10.7. Seems to work fine. I can't speak to the installer as I installed in a previous OS and upgraded to 10.7 recently. (I know some programs had problems with the installer in 10.7, but I have no idea if that affects SBP). So the pro is: it works great in 10.7 (for me). The application itself works like a charm for its intended purpose. The only con is that there is sure to be a SBP 2012 around the corner. You might check when SBP 2011 was released and consider waiting if it looks worth the wait.
I just purchased Sketchbook Pro and tried to install it on my mac, G5 running OSx 10.5 leopard. It says it will only install if the os is intel based. The Amazon sell page does not mention the intel requirement. So is there a SBP for the older G5 mac?