We haven't thought that much about it actually. The only experience I have with it is that the whole web is filled with crappy spam sites that is using the content from Stack Overflow to earn a few extra bucks and that is kind of irritating.
Maybe someone has done something really useful with the data as well that i don't know about though.
But if someone have any awesome idea and want to do something together we are always listening :)
It was actually pretty easy to deal with. Since we usually have around 50-70K visitors/day we are used to a lot of traffic.
Our setup is one Windows Server 2008 R2 with 12gb RAM and Intel Xeon E5520 @ 2.27Ghz with 8 cores. The page is built with ASP.NET MVC + Web Forms (The alternative page is Web forms).
Anyway, ASP.NET scale really really well and since only a small % actually login to the site we can just cache more or less everything. Usually when sites go down because of massive traffic increases i think there is some kind of bug somewhere or they are just being blocked by their hosting provider.
Maybe someone has done something really useful with the data as well that i don't know about though.
But if someone have any awesome idea and want to do something together we are always listening :)
/Ola