mod_fcgid (note the 'd' at the end) actually worked, and works pretty well. I only just now migrated away from it in favor of Passenger, which is easier to configure and has most of the same advantages, as well as being more actively developed.