This video of the Word Lens iPhone app speaks for itself, and it's crazy cool! The app promises to translate languages via the iPhone's camera. Is it worth $9.99 for one language only? You decide, but it's crazy cool!
Currently the program only supports Spanish to English, and English to Spanish, but I imagine they will have other languages soon.
If you try the demo it will reverse words that it sees instead of translating.