Bongo is a flexible and usable buffer-oriented media player for Emacs. Here are some useful links:

• Savannah project page
• Bongo page on EmacsWiki
• Introductory tutorial