Viper007Bond who is the guy behind the new oEmbed feature in WordPress 2.9 suggested that there be a way to add support for some more sites out of the box that don’t support oembed.

Erm, no I didn't. :)

I was asking for a bit of a brainstorm of what the popular video sites were so that they could be supported natively by WordPress. Someone else suggested a UI (rather than the existing function call) for being able to add more whitelisted oEmbed providers so non-admins could use them. Completely separate things.