AFAIK, mod_nsd would have to implement the DB API, pooled DB connections and much of the embedded Tcl calls that the ACS relies on. Even then, you wouldn't get the efficiency of AOLserver since everything is so well integrated.
So I think that Apache + mod_nsd is kinda like souped-up Honda to AOLserver's Ferrari. The souped-up Honda might be fast and have good performance, but it's not quite like driving a Ferrari that's been designed from the ground-up to burn rubber.
That being said, you wouldn't use a Ferrari to go to the grocery store. AOLserver is built for high performance, databased-back websites and that's what it does. Apache is a great tool, but it was designed to pretty much do everything.
Wait, I take that back. Apache was never designed. Maybe 2.0 is different, though.
talli