As far as AVID software goes, productions that have the budget usually go with a Film Composer or a Media Composer 9000. Both are designed to handle the film in its 24fps native rate. The advantage to using the Media Composer 9000 is that it comes with Protools for editing sound. The MC 9000 comes with all the bells and whistles (film options, 3D effects, sound editing and manipulation, etc.) whereas the Film Composer has fewer options and is geared mainly towards Film. Film Composer is being phased out because it is fairly expensive, options are limited and you can obtain the same results by adding film options to the Media Compser Offline for half the money.
The other versions of AVID software (MC 4000, 1000, MC offline, Xpress) can be obtained with the Film matchback option, which means that you take a 30fps video project and match it back with a cutlist to your original negative. It's a bit less precise, but it works fine. The Xpress versions are the least expensive, offer the fewest options but are easy to use. Remember, we're talking about some pricey equipment, 100,000 for a MC 9000 and 25,000 for an Xpress.
If you don't have that kind of money, Adobe Premire is always an option. You can create a cutlist and matchback with that. The software will run you $600. You can use Premiere to edit films but it can be difficult for anything longer than a short. It is done though, and with little difficulty.