I've never run a site with more than a few hundred users before but if you need more 'juice' to handle high volume traffic you could always up the prefork setting.
There are also a few tcp knobs, that you probably shouldn't touch, that are mentioned in the httpd.conf(5) manual page. Other than that, just make sure to keep track of how full your pf(4) state table gets. Regards, JP