Came across this neat app recently (recently bought by Google). Best part is that it works completely offline and exclusively uses the camera feature. You point the camera to a sign or perhaps a a strange looking product the supermarket shelf, and it replaces that text with an english translation right in the camera screen. It won't work as well with books or other small print but for simple signs and other labels with big letters it's neat!
More details here: