Software to merge files from diff devices

Guys

I'm hoping someone here will have found a solution to the following issue - over the years I have acquired 5 or 6 diff video-recording devices, including a Panasonic TM700 camcorder, a Panasonic DMS-TS2 camera, a Canon SD780 camera, etc. We use each of these in different circumstances, sometimes 2 or 3 of them within a single day, and of course each records in it's own resolution/format. Is there a software package out there where I can mix and match clips from all these devices (in the order they were recorded) and render to a common output? I'd be happy to render down to 720p if necessary, or 1080i or whatever. If no single package will do this, what are the recommended programs? What I'd really like would be to have software look in the meta info at at the recording time of these clips and list them in order of acquisition, but if that's not possible I may be able to script up a renaming programn to accomplish that.

Much appreciated!

Thanks for the replies. I already owned Vegas 9.0, it's a great program but when I used files from different cameras the output was completely messed up. Same for the demo version of Vegas 11.0 It never complained either, which was strange, I would have thought that if it couldn't accept different simultaneous input formats it would have said so.
The suggestion to check out Neo3 was a great one. I am seriously impressed, which is good since it costs $200 . The interface was completely intuitive, I drag-and-dropped a months worth of folders on it and it sorted the folders by date and the clips by recording date. I dropped them on the timeline (4 diff devices ranging from 720p to 1080 60p), chose 720p output and it rendered a perfect file, audio in sync and everything. Same for a 1080p render.
When Vegas failed me earlier this year, I spent a month messing around with ffmpeg and mencoder (and tsmuxer, eac3to, etc. etc.) trying to get my files into a common format and I could never get it to work. I can tell you that I will be buying Neo3 despite its high cost, because what it does is not trivial but I really need it.

Thanks Alan! I have a couple of questions if you don't mind:
1) How do you create the chapters? That would be superb
2) When I start a progect I get a message "Preview: Device does not support current format, switching to software mode". Any idea what this means? I have a Nvidia GTX560, is that not supported by Neo3?