CRUD apps are boring. Even if the process of development is made less boring, the final product is still just a CRUD app. :)
E.g, is Twitter a CRUD app? At the programming level maybe, but the core idea behind the service is quite different.
And there are the more interesting non CRUD apps. Google Docs. Google Maps. Photoshop.com. Multiplayer online Games. Online Editors. Online Validators. Real-time collaboration apps. Etc etc.
Google Search is one obvious example of a web app that has absolutely nothing to do with CRUD. It uses a search algorithm to search a massive priority-ranked data structure that represents an index of many millions of popular web pages.