Depends what you're using it for. Scorching ray will do more damage per cast, but produce flame works in both melee and at range, and works over multiple rounds so you don't have to waste spells (or use a crossbow). They fill two entirely different niches.
Heroes of Horror, same as the...