there are lots of things you can't do or can't do easily or can't do at efficiently in Apache using python as cgi or as anyone would more likely assume mod_python. anything that requires any shared state or shared resources in Apache is next to impossible. Doing similar things in an app server or network application framework like twisted is trivial.
-- http://mail.python.org/mailman/listinfo/python-list