Wii Media Center has been released. It lets you consume your movies, music, and photos all in less-than-glorious standard definition. It’s unlike many console-based media players in that it’s been written from scratch and is not based on the mature XBMC platform.
The one thing it won’t let you do is play games. You’ll need to keep using the excellent USB Loader GX for that.