I agree, Source Film Maker is awesome!
I did a roundup of tools for realtime 3D content creation on the same blog a week or so ago, and talked about it there.
http://www.antipope.org/charlie/blog-static/2014/01/resource...
Personally my favourite SFM film is this adaption of the "Robot Hell" song from Futurama: