Goldwave.

http://goldwave.com/

Audition is Cool Edit, renamed when Adobe bought it from Syntrillium. It does permit you to import video clips and edit their audio while previewing picture. It only supports one video clip at a time however so you would use it in conjunction with your video editor, most likely Premiere I'd imagine, for your complete edit.

There are a lot of good DAWs out there. Protools is the standard but not necessarily the best. I would recommend downloading demos of the major apps and trying them out. It really comes down to which DAW gives you the best work flow as they pretty much do the same things.

I use Sonar 7 with a RME Fireface 800 and love it. I also have an 002r with PT LE but never bought the DV toolkit. I have debated on getting a full TDM system but it’s hard for me to justify the cost. So I mostly use Sonar and it does almost everything I need it to do. Plus I really like cakewalk as a company as they really seem to listen to and care about their customers. I also like that I can use the hardware I want.

I import all of my audio tracks into Steinberg Nuendo, and go from there. It's a fantastic program and has gotten easier and more powerfull in the last few years. Once I'm done splitting tracks, eq'ing , compressing and everything else, I do a stereo mixdown, and do my final tweaking and mastering in Wavelab.
We do a lot of weddings, and typically end up with several mic tracks (usually one needs splitting the lav and gun). I add music tracks and sometimes compose my own aditional sweeteners. I originally started with cubase, then Nuendo, for song peoduction and recording, and then found it great for video. I know that the industry standard is Pro tools, but I've been using cubase and nuendo for 10 years....
Bruce S. Yarock
www.yarock.com

Sound track pro and audacity