The Pleco Chinese-English dictionary iPhone app does realtime lookups using the camera. It's more of a study tool than a realtime translation tool, but still really cool:

http://www.engadget.com/2010/11/24/pleco-chinese-dictionary-...