Comment Roundup Issue Tracker (Score 2, Interesting) 321
http://roundup.sourceforge.net/
FOSS, not freeware, web-based issue tracker written in Python. It's extremely flexible and customizable to your needs, as every organization is different.
It comes with an embedded webserver so you can get it running quickly, and of course it works with apache/mod_python.
As for email, you can create, update, and close tickets via email using keywords/value pairs in the subject line.
I miss this ticket tracker. I work for a consulting firm where we need to handle multiple clients and time tracking w/ billing, so that's a bit beyond roundup's mission. We're using Autotask, and nobody likes it.