If you're interested in Apple TV apps, also check out what Firecore is doing (http://firecore.com/atvflash-black).
Their "aTV Flash" product is $30 and can be added to a jailbroken Apple TV 2 (the third-gen ATV has yet to be jailbroken). It makes it easy to add weather, RSS, a browser, XBMC, Plex, and some other apps to the ATV.
Most notably, however, is their own "Media Player" app, which is a pleasantly robust media center (think XBMC if it were made specifically for the Apple TV). It handles almost any file format I throw at it without fail and is a much better experience than XBMC's own ATV app in my experience.
I can't wait for Apple to officially release the ATV SDK and really open the floodgates, but it feels like pre-March 2008 all over again (when Apple announced the iOS SDK).