As to the type of camera, I don't think it matters that much. What's more important is the ability to fill the frame with the negative. I found a 50mm lens (crop sensor) with a single extension tube did the job (for 35mm). If you're scanning 120, 6x17, 4x5 or anything bigger, your requirements will vary. If you have decent backlighting, you can knock the ISO down, and if you're on a stand the shutter speed can be slow, so low light performance is irrelevant.
I gave it up because of the space requirement, inability to keep the neg flat without another contraption, and the hassle of Lightroom (as Chris mentioned). Neg Lab Pro is well worth the trial if you go down the "try it" route as it's relatively quick compared to the 'curve swap and sliders doing the opposite'. Esp with colour film!