The plugin for PPC is available from the Mac OS X download page. As far as I can tell from looking at the source code, the only supported MIME types in the VLC 0.8.6 release is application/ogg, application/x-ogg, application/x-vlc-plugin (?) and video/x-google-vlc-plugin.
I don't know if the 0.9.0 version of the plugin is packaged and available for download (or even working), but it seems to include support for many more MIME types. I built the plugin with latest source from trunk on my Macbook, unfortunately with no luck. Both Safari and Firefox 2 crashes every time I try to view any site with embedded video.
Only the developers know the current status of the plugin code.