I wrote a couple of scripts in vb/vbscript. I can't help with much, but here's what I learned:
[ul]
[li]The object model confuses me to this day. I'm sure it makes perfect sense once you understand it, but I could never really access certain things (like all tables in a document, for example).
[/li]
[li]There are definitely some things you simply can't do -- you can do them with the mouse or a keyboard shortcut, but not via scripting.
[/li]
[li]The Adobe forums (there's an ID scripting forum) are the absolute best source of help/info that I could find.
[/li]
[li]Raw VBScripts -- text files with .vbs extensions -- ran WAY faster than compiled VB or the VBA console. To the tune of 40 or 50 times faster, for many things. This was counterintuitive to me, but after I figured it out I just used raw text files.
[/li]
[li]For all my complaints, I shaved literally hundreds of hours off of my project. My little scripts to localized table formatting, trying to mimic table "styles," sort of, were really helpful.
[/li]
[/ul]
Note that all of this advice relates to ID 2.0, not CS, and things certainly could have changed between versions.