I also remember a piece of software called First Row? that brought all your music,vids in one place and had a carousel like interface. I'm sure this came out before the original Apple TV too.
Front Row was great! I used to rip my DVDs as disc images - Front Row could handle those nicely. Now I have to take the extra, time-consuming step of extracting any DVD or Blu-Ray content I want to keep into separate video files... and occasionally that's not even possible with particular extra features (like some types of slideshows).