The best known exemple of a Hadoop-powered application so far: Yahoo Search Webmap, a.k.a. the index behind their entire search service (http://developer.yahoo.com/blogs/hadoop/2008/02/yahoo-worlds-largest-production-hadoop.html).
Other cases at http://wiki.apache.org/hadoop/PoweredBy.