The hackers solution. A media server running mpd or XMMS2, with the proper metadata organizing utility for your medialib. Plus running mplayer and possibly some ffmpeg tweaking for when you're out in the deep end. Plays anything, anywhere, and leaves the rest up to your imagination.

I guess Miro is great, but any complete solution will always be inferior to the proper tools for the right jobs.