* Comments on stories that appear seconds after posting
* Latest-comment lists (this one is a performance nightmare for anything other than the simplest cases)
* Navigability by category, author, tag, date
* Twitter integration
And so on and so forth.
There are, basically, two platonic models of web applications. The first is the compiled, the second is the dynamic. Compiled web applications perform all computations in advance and reduce to static resources. Dynamic web applications perform all page rendering on-the-fly and only a small subset of a page is static (JS, CSS and images, mostly).
Naturally, most apps fall in between on the continuum. For example, Movable Type used to have a simplistic compilation scheme that would rebuild large portions of the site due to small changes. For a while one of the selling points of Wordpress was that it updated instantly. But that too came at a price, and now on any busy site using it, Wordpress is usually chaperoned by a bodyguard of caching systems.
My personal thinking is that the sweet spot will be in managing changes to a site through queueing and selective compilation. This is what we have in practice, but I want to move the key queue from GET -> cache -> app -> db to being POST -> db -> app -> cache.