Flash video sites generally work pretty well. I regularly use my n900 to watch youtube videos, robot chicken videos on adult swim, and anime on streaming video sites.

As previous posts have said its not nearly as good as a desktop computer experience but its the best flash experience you'll get on a mobile phone.