Q: Can I use mod_python, Zope, mod_perl, etc.?

If they support suexec, the answer is probably. If not, you will probably need to run your own web daemon to do it. Many of these are not designed to work in an environment like ours, where resources are shared by mutually untrusting users; as a result, they run all scripts as the same user, which would let others trample your data, either intentionally or through negligence. We do support (and will assist you with) running your own daemons and proxying from our main Apache, though, so no worries!