It's great for writing small one-offs (the sort of thing you might use PHP for) and web interfaces for non-web applications. But for large projects it's really not suitable.
Our latest site, http://sitecanary.com/ has the UI completely written in webpy.