To answer your questions:
> 1. How involved is the scripting process?
You could get by with using JavaScript but most script developers I know prefer to use C#. Just download the Vegas Pro 8.0 Script Developers Kit from the Sony site for the documentation and some good code examples. See if it’s something you might want to tackle.
> 2. Would it make sense in my case to proceed with learning the process?
That depends on how valuable your time is. You will need to make an investment in understanding the Vegas Script SDK object model and it does have it share of pitfalls and workarounds that you need to be aware of (meaning if you point a gun at your foot it will let you pull the trigger unlike the Vegas GUI that may stop you from doing something stupid)
As Edward pointed out, there are scripts on the market that already do this. In addition to Excalibur, the VASST Ultimate S Pro tool has two ways of accomplishing this. There is a tool to Delete Between Markers and one to Keep / Remove within Regions which would keep everything you have placed a region around, delete outside whats is outside, and ripple the gaps so that you are left with one continuous timelne with only the events you want and no gaps.
> 3. Can scripting help my workflow?
IMHO, scripting in Vegas Pro is the biggest productivity enhancement of any NLE. I can’t imagine an efficient workflow without the use of scripting but I am biased. 😉
> For example can a script cut the video and each marker, delete what I don’t want and squeeze all the other clips closer together?
Yes, and as I mentioned, the Ultimate S Pro Keep / Remove within Regions function does exactly that with one click! You can buy the answer or you can build the answer yourself. It’s your choice.
~jr
http://www.johnrofrano.com
http://www.vasst.com