mod_wsgi, mod_python, or just cgi?
mod_python is dead, so using mod_python probably isn't a good idea for new projects. Personally, I prefer to use mod_wsgi over CGI (or FastCGI). It's dead-simple to set up, and much more efficient.
Don't use CGI. It's inefficient. Spawning a new process for each request. No thanks
Dont't spend much time with mod_python
Use mod_wsgi.
If you want to write CGI-like stuff without a framework, use mod_wsgi anyway. The WSGI standard (PEP 333) is essential for creating web applications in an easy, interchangeable, reusable, plug-and-playable way.
I would go with mod_wsgi too.
If you want a deeper understanding about the question, have a look at this:
- Apache, FastCGI and Python, by Ferry Boender
Good stuff!