Not that I watch that much video on my Nexus One, but I'm glad that Skyfire brings Flash support to my device. No more of those pesky messages that my browser does not support Flash and offers me to download the unsupported application.
That said, Skyfire is supposedly avalaible for download via Android Market. My last search there did not yield any result. Or point your browser to HTTP://get.skyfire.com.