It depends a lot on what you're going for. For example this video of a tiny cat wearing a tiny hat eating a tiny ice cream cone as an ad for an ice cream company has hundreds of thousands of views: http://www.youtube.com/watch?v=AMnpWYaCKB0
As a person, I love this video. I show everyone, it's kind of ridiculous. As a marketer, I'm curious about it's value in terms of direct human visits to the ice cream shop. I've seen this video many many times, and for the life of me as I write it I can't think of the name of the shop. I'm also east coast based, so my love of small cats doesn't transfer into money for their shop. Obviously they're building brand awareness (and improving their rankings) but they aren't necessarily bringing people in the door.
Conversely, lots of law firms (my specialty, shameless plug) and other complicated service companies will have informational videos on various parts of their practice. It usually does very little for SEO since these videos barely break 1000 views, sometimes even 100. However, we've noticed a great return on these ads, since they fulfill a specific need, and are so highly specific (long tail search for location, type of lawyer, specific legal claim) that the few people who do see them are generally far in the buying cycle, and contact us.
It really depends what your goals are. Finally, this article on the moz blog " A SEO's Guide to Video Hosting and Embedding" is very helpful. :http://moz.com/blog/hosting-and-embedding-for-video-seo