I've had a lot of fun with https://github.com/mifi/editly. It seems a bit RAM hungry as you define lots (dozens?) of clips thought.

I found it super useful to write a quick Python script to auto-generate JSON in the format it wants, combining screenshots, headers, footers, and such into a nice demo-video.