Plex, EyeTV with HDHomeRun (dual tuner) & FrontRow.
Plex can't play the DRM video files from Apple but the plugins, Plwz Apps and ability to access other installed applications makes Plex a great launch point for a Mac mini HTPC. Throw in a Logitech Harmony Remote and you're good to go.