I believe Google's search engine was originally written in Java if you're looking for an inspiring Java webapp. App engine obviously didn't exist yet though.