Can Blender take two video files and overlay them with transparency?
Yes, this is possible.

To overlay a video, simply layer one on top of the other in the VSE timeline.


To make the top one transparent, simply use the opacity slider in the properties panel. 0 is for fully transparency, and 1 is for full opacity.