Unity does require programming, but Unity provides one of the easiest (and most fun) ways of learning.
If you want to make a simple game, then chances are someone has coded a variation on the premise before, and can provide tips to help you get through it as a first project.
If you want to make a larger game, then you will obviously have a lot to learn before you get to that point.
As long as you take it slow, don’t expect too much from yourself at the start, I think you will be pleasantly surprised with what you can do.
I’d recommend starting out by going through the tutorials and guides in the resources section and assess for yourself. Also check out the wiki and this forum of-course.
Unity has a lot of potential for pre-vis work and the like. Machinima is really just “3D animation” by another name; the gap between them will close eventually as the technologies mature.
There’s no built-in lip sync support in Unity as such, but it’s not that hard to add such support. You could either build a lip-sync editor which runs in the IDE itself, or you could write a script which imports a file from an off-the-shelf lip sync tool.
(I’m considering writing something like this myself.)