i feel you most informed response will come form the denizens of
rec.audio.pro.
i would suggest your subject line be something like: help with recording
software and keyboard selection
for your Foley recording you might state whether it needs to be portable or
not. does the sound come to you or do you go to the sound? mono or stereo?
as a general purpose mic you might look at the Rode NT-5
Adobe Audition is my preferred recording software, however i only scratch
the surface of it's capabilities. to find whether it will fill all or part
of your requirements you will have to wade through the info at http://www.adobe.com/products/audition/
for DC burning i find Roxio to be friendly. Nero works ok too.