This is an idea I've often wondered about myself. It seems much more preferable to give some a few people good access rather than everyone poor (or worse) access.
I use it in front of a mongrel cluster to make Rails app fast. Apache serves up static files (images, stylesheets, js) and I use mod_proxy and mod_proxy_balancer to load balance requests for dynamic content among the mongrel servers.
I'm using it with Django. Is there a better option I'm not aware of? Everything else they suggested in the manual seemed too hackish - though I'm not a fan of Apache either!
I'll have to take another look at that. We're bottlenecked by static file serving on a per server basis (a typical page is 1.5-6mb of traffic), so it's not a big priority. But it definitely will be if we move to separated out static + dynamic servers, or if we build out more dynamic places on the site that don't involve serving up a game.